Hi all,
I have about 48 data sets named
pfreq_and_pl_g1_gr1
pfreq_and_pl_g1_gr2
pfreq_and_pl_g1_gr3
pfreq_and_pl_g1_gr4
pfreq_and_pl_g2_gr1
pfreq_and_pl_g2_gr2
...
"g" goes up to 12.
and "gr" goes up to 4.
I want to merge them based on the "g". For example one merged data set will include (pfreq_and_pl_g1_gr1, pfreq_and_pl_g1_gr2, pfreq_and_pl_g1_gr3, pfreq_and_pl_g1_gr4), the other data set will include (pfreq_and_pl_g2_gr1, pfreq_and_pl_g2_gr2, pfreq_and_pl_g2_gr3, pfreq_and_pl_g2_gr4).
Merging will be based on the data set's name, not a variable. How can I do that?
Thank you
If those datasets share the same structure, you probably want to.stack them, not merge.
Try this:
%macro dsnames;
%do i = 1 %to 12;
%do j = 1 %to 4;
npfreq_and_pl_g&i._gr&j.
%end;
%end;
%mend;
data final_grade;
set
%dsnames
indsname=dsname
;
group = input(scan(dsname,-1,'r'));
run;
not tested, posted from my tablet.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.