topic Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4 in SAS Data Management

Question to include value '0' as prefix for the field values in Data Management Studio 2.4

Shah — Fri, 24 Apr 2015 03:56:09 GMT

I have input field name as COCD which contains values and length of value is upto 4 digits. I require the output to be in 4 digits for all the values. It means that if the COCD = 1 then the output should be changed to 0001. Is there any function to perform these type of changes?

I have tried the below expression but didn’t get the correct result :

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

COCD	Desired Output
5	0005
8	0008
33	0033
44	0044
555	0555
6666	6666

Regards,

Shaheen

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

Ksharp — Fri, 24 Apr 2015 14:59:28 GMT

How about assign a format to it ?

format cocd z4.;

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

Haikuo — Fri, 24 Apr 2015 15:10:10 GMT

you don't need 'if' condition, just

cocd_text = put(cocd, z4.);

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

Reeza — Fri, 24 Apr 2015 15:11:32 GMT

That isn't SAS code or straight SQL either.

use the the put function with z4 format.

cocd_text = put(cocd, z4.);

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

ballardw — Fri, 24 Apr 2015 15:51:26 GMT

One would also ask if these values started with leading zeroes and they disappeared when brought into SAS. If that is the case I would look at my input to see if that could be corrected there, unless of course you are doing arithmetic with COCD.

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

skillman — Fri, 24 Apr 2015 17:14:06 GMT

This expression will give you what you want:

/* 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

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

Shah — Mon, 27 Apr 2015 07:15:08 GMT

Dear Skillman,

Thank you for your codes. It is working fine.

Regards,

Shaheen

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

Shah — Mon, 27 Apr 2015 07:23:16 GMT

Hi ballardw,

I cannot change the input of file hence trying other options. I have received answer for the above question. Thank you.

Regards,

Shaheen

Hi Reeza, Hai Kuo, xia keshan,

I am new to this and not sure of what z4 format is. However i have received answer to my question. Thank you.

Regards,

Shaheen

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

Kurt_Bremser — Mon, 27 Apr 2015 07:43:18 GMT

Pardon me, but what type of code is that? Looks like no language I ever saw.

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

skillman — Mon, 27 Apr 2015 12:26:50 GMT

It is a SAS Data Management Expression code. The original poster asked for help within SAS Data Management Studio, and this was exactly what he wanted.

-shawn

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

DaveR_SAS — Mon, 27 Apr 2015 13:55:11 GMT

If you would like to know more about the expression provided by skillman, see the DataFlux expression language reference: http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.5/dfU_ELRG.pdf

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

Tom — Mon, 27 Apr 2015 19:19:28 GMT

That logic seems way too complex. I have never programmed in that language, but the code could be much simpler.

string desired_output

desired_output = `COCD`

while len(desired_output) < 4

begin

desired_output = '0' & desired_output

end

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

ricardo_benatti — Tue, 30 Jun 2015 14:08:49 GMT

hi ....

to evaluate the group ...

could be a solution, simpler,

receive in a variable, the concatenation of the "N" ZEROS characters, right, with the content attribute:

INPUT:

ID	CODE
111	20
112	40
113	20
114	40
115	CMR2
116	CMR3
117	20
120	20
121	20

EEL >> PRE PROCESSING

string(11) W_2_ZEROS_LEN_11

string(04) W_2_ZEROS_LEN_04

EEL >> PRE PROCESSING

W_2_ZEROS_LEN_04 = right( "0000" & trim( `CODE` ), 04 )

W_2_ZEROS_LEN_11 = right( "00000000000" & trim( `CODE` ), 11 )

OUTUPUT:

ID	CODE	CODE_4_ZEROS	CODE_11_ZEROS
111	20	0020	00000000020
112	40	0040	00000000040
113	20	0020	00000000020
114	40	0040	00000000040
115	CMR2	CMR2	0000000CMR2
116	CMR3	CMR3	0000000CMR3
117	20	0020	00000000020
120	20	0020	00000000020
121	20	0020	00000000020

Regards,