Hi
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?
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
Thanks for reply. My system was down for some weeks so, could not reply.. Thanks, I have got the solution.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.