topic Re: Pass a Dataset as a Parameter in a Macro in SAS Programming

Pass a Dataset as a Parameter in a Macro

whs278 — Fri, 13 Sep 2019 18:45:51 GMT

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.

Re: Pass a Dataset as a Parameter in a Macro

ballardw — Fri, 13 Sep 2019 19:19:09 GMT

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.

Re: Pass a Dataset as a Parameter in a Macro

whs278 — Fri, 13 Sep 2019 20:02:43 GMT

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