Pass a Dataset as a Parameter in a Macro

[whs278]

This is a question coming from an R user who is now using SAS for his job.

Basically, I want do something in SAS that would be equivalent to applying a function to a dataframe in R.  I was thinking of possibly passing a dataset to a macro.

My goal is to run a set of Proc Freq on different datasets without having to copy and paste the code each time.  

[ballardw · Accepted solution]

Basic macro approach:

%macro dummy(dsn=);

proc print data=&dsn.;
run;

%mend;

%dummy(dsn=sashelp.class)

Or you could pass the library and set name separately if you define the macro with more parameters. Then build the combined reference with something like. &lib..&set.

[whs278]

Thanks.  I didn't know about adding that period.