topic Re: Convert do loop sequence to Char Variable in SAS Programming

Convert do loop sequence to Char Variable

Jcorti — Fri, 17 Feb 2017 14:55:25 GMT

Hi Guys,

I have this data step:

And I want to convert last field - sequence of **i** value to char:

data one;
array c {25} $ ('00' '01' '02' '03' '04' '05' '06' '07' '08' '09' '10' '11' '12' '13' '14' '15' '16' '17' '18' '19' '20' '21' '22' '23' '24');
*c{i}=put(c{i},$2.); ** I tried with this and it does not work**
do i='00' to '24';
output;
end;
run;

After execution of data step, I got this in the last field:

0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

and I want:

00
01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

I tried to convert that sequence number in char and I was not able to.

The scope of this that I want to use this **char** sequence like a macro variable.

Do you have some work around on this??

Thanks and regards,

José

Re: Convert do loop sequence to Char Variable

ballardw — Fri, 17 Feb 2017 15:06:03 GMT

If you have a NUMERIC variable that you want to display with leading zeroes you do not need to create a text variable you can use a Z format to provide them.

or possibly what you want is

data one;

array c{25} $;

do i=0 to 24;

c[i] = put (i, z2.);

output;

end;

drop i;

run;

Re: Convert do loop sequence to Char Variable

Kurt_Bremser — Fri, 17 Feb 2017 15:27:23 GMT

The iteration variable from the do statement is always numeric, so either use a Zw. format for display, or do

data want (keep=i);
do i1 = 1 to 24;
  i = put(i1,z2.);
  output;
end;
run;

to get a character variable in your dataset.

Re: Convert do loop sequence to Char Variable

ballardw — Fri, 17 Feb 2017 16:02:16 GMT

Minor correct to @Kurt_Bremser, an iterated do loop will accept an explicit list of values separated by commas but will not all the From - To-(and especially By).

data junk;
   do c='00','01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24';
      output;
   end;
run;

Re: Convert do loop sequence to Char Variable

Jcorti — Fri, 17 Feb 2017 16:14:39 GMT

Thanks a lot for your information ..It worked properly 🙂

Re: Convert do loop sequence to Char Variable

Jcorti — Fri, 17 Feb 2017 16:15:16 GMT

Thanks a lot ..It worked 🙂

Re: Convert do loop sequence to Char Variable

Jcorti — Fri, 17 Feb 2017 16:16:17 GMT

Thanks a lot it worked 🙂