Need qlik function from SAS function.

[chinnu123]

Hi Team,

PIN_RT = PUT(INPUT(PIN,BEST11.),Z11.);

I need to convert above SAS function in qlik.

Can any one explain me how the above function works and how to write in qlik.

Thanks,

Chinnu.

[techvarun · Accepted solution]

Repeat('0', 11 - Len(PIN)) & PIN AS PIN

[chinnu123]

Hi Varun,

Thanks for your quick reply, Can you please tell me How the above expression works.

Thanks,

Chinnu.

[techvarun]

Hi,

I am taking 11 as my base number (Z11) the function first check for the number of available digits

Len(Pin) then it will repeat 0 for 11 - Len(PIN) times

For example.

9911223344 is the input then it will add

11- 10 =1 zero to the input.

try below script

Test:

LOAD * INLINE [

Field

   9916344747

   122222

   1222212

];

LOAD

Repeat('0', 11 - Len(Field)) & Field AS Field1 Resident Test

[chinnu123]

Thanks for your Explanation Varun.

Thanks,

Chinnu.