topic Re: SAS Macro in SAS Programming

SAS Macro

PetePatel — Mon, 18 Oct 2021 15:33:29 GMT

Hi,

I have 100 large datasets (a,b,c,d,e...) and 50 variables that I need to exclude from those datasets in a set statement.

How can I set up a Macro to efficiently exclude these from each dataset before creating the final dataset 'want'?

variables to exclude:

d1, d2, d3, f1, f4, g7, h9...etc

data want;

set

...

run;

Re: SAS Macro

PaigeMiller — Mon, 18 Oct 2021 16:00:41 GMT

No macro needed

data want;
    set a b c d e ... ;
    drop d1 d2 d3 f1 f4 ...;
run;

or if you really want to improve the efficiency of the execution time (Again no macro needed but a macro variable ... which is not a macro ... is used)

%let excl = (drop=d1 d3 d3 f1 f4 ...);
data want;
    set a&excl b&excl c&excl ...
run;

Re: SAS Macro

PetePatel — Mon, 18 Oct 2021 16:05:37 GMT

Thanks PaigeMiller. The variables need to be dropped within the set statement as they are causing issues when trying to set together. Your second macro code is what I was after.

Re: SAS Macro

PaigeMiller — Mon, 18 Oct 2021 16:10:04 GMT

@PetePatel wrote:

Thanks PaigeMiller. The variables need to be dropped within the set statement as they are causing issues when trying to set together. Your second macro code is what I was after.

Great. But there are no macros here. There is a macro variable, which is not a macro.

Re: SAS Macro

ballardw — Mon, 18 Oct 2021 16:10:15 GMT

@PetePatel wrote:

Thanks PaigeMiller. The variables need to be dropped within the set statement as they are causing issues when trying to set together. Your second macro code is what I was after.

If the particular issue(s) were mismatched variable types or lengths of character variables it may be time to address how the data sets are created.

If the issue was just data set size that's another story.