topic Merging more than 2 data sets in SAS Programming

Merging more than 2 data sets

aoifeoneill — Tue, 19 Sep 2017 10:00:02 GMT

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!

Re: Merging more than 2 data sets

Astounding — Tue, 19 Sep 2017 10:14:06 GMT

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);

Re: Merging more than 2 data sets

aoifeoneill — Tue, 19 Sep 2017 10:19:41 GMT

Thanks @Astounding, I wasn't aware of '-' being available.