topic Re: Do until in SAS Procedures

Do until

R_Win — Tue, 05 Apr 2011 06:36:24 GMT

HI i want to add '0' before the id variable by using do until can any one help me.

data a;
input id $;
len=length(id);
do until (len=5);
a='0';
id=a||id;
end;
stop;
output;
cards;
1
01
001
run;

output
00001
00001
00001

Re: Do until

GertNissen — Tue, 05 Apr 2011 09:53:05 GMT

Must it be by using the do loop ?

Or perhaps you can use the following

data a;
input id 8.;
id2=put(id,z5.);
cards;
1
01
001
;
run;

Re: Do until

ballardw — Tue, 05 Apr 2011 17:34:25 GMT

You need to update the len value within the DO loop.
Also, if you want to see the results of each iteration of the loop you need the OUTPUT within the loop as well.

data a;
input id $;
len=length(id);
a='0';
do until (len=5);
id=a||id;
len=length(id);
output;
end;
cards;
1
01
001
run;

You also should consider what might happen if the length of your input variable is greater than 5.