topic Re: Question to convert the field type in Data Management Studio 2.4 in SAS Data Management

Re: Question to convert the field type in Data Management Studio 2.4

Shah — Thu, 23 Apr 2015 10:30:53 GMT

I have tried the above tostring function and it is working fine. Thank you so much for the above solution and also regret for the late reply.

I have one more question to ask, I have the field COCD with the len 1, 2, 3, and 4 digits. The COCD column must consist of 4 len number as per our requirement so i have to prefix each company code with '0' to make it 4 digit. Is there any solution or functionality i can use to change the len to 4 digits?

I have used below the expression but not yielding result:

if len(COCD) == 1 then cocd_text = left(000,COCD)

COCD	Required Output
1	0001
2	0002
11	0011
22	0022
333	0333
4444	4444

Regards,
Shaheen

Re: Question to convert the field type in Data Management Studio 2.4

skillman — Fri, 24 Apr 2015 17:17:19 GMT

This was answered here:

but to save you a click here is the solution:

/* Pre-processing Expression*/

string desired_output

hidden integer i

desired_output = ''

i = 0

/*Expression*/

if len(`COCD`) < 4

begin

desired_output = `COCD`

while i < (4 - len(`COCD`))

begin

desired_output = '0' & desired_output

i = i + 1

end

else

desired_output = `COCD`

i = 0