Hi,
I would like to write a macro to merge more than 2 data sets (100 datasets to be exact), keeping only log-likelihood values in one column. Rather than type the name of every data set I tried the following code:
%macro merge (n=100);
%Do i= 1 %TO &n;
%LET j=%EVAL(&i+1);
data LogLall;
set LogL&i LogL&j;
keep Log_Likelihood;
run;
%END;
%MEND;
%merge;
The issue is only the final two datasets' values get saved to the new dataset. I want the final dataset to look as follows, but with 100 observations.
Any ideas how to save more than 2 datasets to the same file?
Thanks!
Have you tried it without macros?
data LogLall;
set LogL1-LogL100;
keep Log_Likelihood;
run;
The only reason to add macro language would be to move the KEEP statement to the SET statement, along these lines:
set LogL1 (keep=Log_Likelihood) LogL2 (keep=Log_Likelihood) ... LogL100 (keep=Log_Likelihood);
Have you tried it without macros?
data LogLall;
set LogL1-LogL100;
keep Log_Likelihood;
run;
The only reason to add macro language would be to move the KEEP statement to the SET statement, along these lines:
set LogL1 (keep=Log_Likelihood) LogL2 (keep=Log_Likelihood) ... LogL100 (keep=Log_Likelihood);
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.