topic Re: Creating Macro variables from list in SAS Programming

Creating Macro variables from list

bnarang — Fri, 04 Jan 2013 11:50:17 GMT

Let's say we have a variable

%let Group = AA BB CC DD;

I would like to produce GROUP_1, GROUP_2 , GROUP_3, GROUP_4.

To start with :

I had a count with of all the words in Group with Countw and I got 4.

Now, next, I tried within a macro

Data _null_;

%do i = 1 %to &num_count;

Group_&i. = %qscan(%bquote(&group), &i.,',');

call symput("Group_&i." Group_&i.);

Run;

Am I doing right?

Jagadishkatam — Fri, 04 Jan 2013 12:24:29 GMT

hi,

please try the below code, as per your if we consider &num_count eq to 4 then

%let num_count=4;

%put &num_count;

Data test;

do i = 1 to &num_count;

group="group_"||strip(put(i,1.));

output;

end;

Run;

proc sql noprint;

select group into :grp separated by ',' from test;

quit;

%put &grp;

Thanks,

Jag

bnarang — Wed, 30 Jan 2013 02:48:25 GMT

Thanks for reply. My system was down for some weeks so, could not reply.. Thanks, I have got the solution.