topic Re: one question about marco in SAS Programming

one question about marco

tianerhu — Sat, 11 Dec 2021 16:01:45 GMT

/*Step 3: Creating sas data sets*/

 /*CDM datasets*/

%macro CDM (Domain= ) ;

PROC IMPORT DATAFILE= "&root./data/data_excel/CDM/&domain..xlsx"
            DBMS=XLSX OUT= CDM.&domain  ;
     GETNAMES=YES;
RUN;

%mend CDM ;

in the parentheses, what is 'Domain='? what role is it ?

Re: one question about marco

Kurt_Bremser — Sat, 11 Dec 2021 16:10:51 GMT

It is a macro parameter, which is used like a macro variable in the macro.

And since it is a named parameter, it must also be supplied as such when the macro is called:

%cdm(domain=xxx)

Re: one question about marco

Tom — Sat, 11 Dec 2021 16:13:52 GMT

Search: @Sas.com %macro statement

https://www.google.com/search?q=%40sas.com+%25macro+statement

Read: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p1nypovnwon4uyn159rst8pgzqrl.htm

The text inside the () in the %MACRO statement defines the parameters to the macro.

So in this %CDM() macro DOMAIN is the name of the parameter.

The equal sign means that you must pass the value by name when calling the macro. So if you wanted to run the %CDM macro for the AE domain you would use:

%cdm(domain=ae)

If you remove the equal sign in the %MACRO statement

%macro cdm(domain);

then you could have passed the value for DOMAIN in the call to the macro just by its position.

%cdm(ae)

Note that even if you define the macro such that a parameter may be passed by position you can always pass the values by name. So %cdm(domain=ae) will work with either way of defining the DOMAIN parameter.

Re: one question about marco

tianerhu — Sat, 11 Dec 2021 19:14:33 GMT

Thank you for your help.

Re: one question about marco

tianerhu — Sat, 11 Dec 2021 19:15:13 GMT

thank for your help.