topic Re: Array,Do loop,Substr in SAS Programming

Array,Do loop,Substr

pearsoninst — Mon, 02 Nov 2015 18:47:12 GMT

Hi All,

I wanted to split my name or any name into 7 varaibles ,The below soluation is working fine ,but it is not working with numbers say i wanted slipt 1234567 into 7 differnet variables. Any help on this.

data newdata;
input Name$ ;
Array myarr (7)$ Name1-Name7;
do i = 1 to 7;
myarr (i)= substr(Name,i,1);
end;
datalines;
kanchan
;
run;
Proc Print data = newdata;
run;

Re: Array,Do loop,Substr

Reeza — Mon, 02 Nov 2015 19:01:59 GMT

Have you tried SUBSTRN() function?

Re: Array,Do loop,Substr

pearsoninst — Mon, 02 Nov 2015 19:09:00 GMT

Thanks , that small 'n' is realy helped . Thank you Reeza...