topic Re: Can someone help me understand why the %match macro wont run? in SAS Programming

Can someone help me understand why the %match macro wont run?

Rover17 — Fri, 04 Feb 2022 20:17:16 GMT

Hi All,

I am trying to run a SAS macro that I found in the following SAS Statistics and Data Analysis Paper:

An Introduction to Matching and its Application using SAS.

I attached the paper to this post.

Below are the two SAS data steps to create the input datasets for the macro. These data steps run fine. But, I cannot get the %match macro to run.

The macro is after the two data step programs below.

Data CASES;
Input PTID AGMT CHK AGMN WT;
Cards;
101 39 1 13 118
102 35 1 14 129
103 28 1 12 108
104 31 1 14 110
105 41 1 13 138
;

Data CONTROLS;
Input PTID AGMT CHK AGMN WT;
Cards;
201 39 2 11 175
202 62 1 11 170
203 35 2 11 170
204 42 1 13 118
205 30 1 14 130
206 39 2 12 135
207 27 2 12 127
208 58 1 10 140
209 36 1 14 110
210 41 2 12 129
211 55 2 13 193
212 45 1 11 154
213 61 2 13 153
214 31 2 11 97
215 28 2 11 145
;

%match(case=CASES, control=CONTROLS, idca=PTID, idco=PTID, mvars=AGMT, wts=2, dmaxk=2,
method=optimal, ncontls=2, maxiter=10000, out=MTCH, print=y); run;

Can someone please help me understand why this %match macro wont run? I get the following output when trying to run it.

71 %match(case=CASES, control=CONTROLS, idca=PTID, idco=PTID, mvars=AGMT, wts=2, dmaxk=2,
-
180
WARNING: Apparent invocation of macro MATCH not resolved.
ERROR 180-322: Statement is not valid or it is used out of proper order.

72 method=optimal, ncontls=2, maxiter=10000, out=MTCH, print=y);

72 ! run;

Thanks

Re: Can someone help me understand why the %match macro wont run?

Reeza — Fri, 04 Feb 2022 20:29:11 GMT

Where is the code for the macro? Did you pull it out of the paper and include it in your code or is it available somewhere else?

To run a macro you need both the macro definition and call and then you can execute it.

Something like this:

*macro definition;
%macro print(ds=);
proc print data=&ds;
run;
%mend;



*macro call;
%print(ds=sashelp.class);

You're missing the first part of the process.

FYI - look into proc PSMATCH which is a built in SAS procedure for doing propensity score matching as well.

@Rover17 wrote:

Hi All,

I am trying to run a SAS macro that I found in the following SAS Statistics and Data Analysis Paper:

An Introduction to Matching and its Application using SAS.

I attached the paper to this post.

Below are the two SAS data steps to create the input datasets for the macro. These data steps run fine. But, I cannot get the %match macro to run.

The macro is after the two data step programs below.

Data CASES;
Input PTID AGMT CHK AGMN WT;
Cards;
101 39 1 13 118
102 35 1 14 129
103 28 1 12 108
104 31 1 14 110
105 41 1 13 138
;

Data CONTROLS;
Input PTID AGMT CHK AGMN WT;
Cards;
201 39 2 11 175
202 62 1 11 170
203 35 2 11 170
204 42 1 13 118
205 30 1 14 130
206 39 2 12 135
207 27 2 12 127
208 58 1 10 140
209 36 1 14 110
210 41 2 12 129
211 55 2 13 193
212 45 1 11 154
213 61 2 13 153
214 31 2 11 97
215 28 2 11 145
;

%match(case=CASES, control=CONTROLS, idca=PTID, idco=PTID, mvars=AGMT, wts=2, dmaxk=2,
method=optimal, ncontls=2, maxiter=10000, out=MTCH, print=y); run;

Can someone please help me understand why this %match macro wont run? I get the following output when trying to run it.

71 %match(case=CASES, control=CONTROLS, idca=PTID, idco=PTID, mvars=AGMT, wts=2, dmaxk=2,
-
180
WARNING: Apparent invocation of macro MATCH not resolved.
ERROR 180-322: Statement is not valid or it is used out of proper order.

72 method=optimal, ncontls=2, maxiter=10000, out=MTCH, print=y);

72 ! run;

Thanks

Re: Can someone help me understand why the %match macro wont run?

Reeza — Fri, 04 Feb 2022 20:28:32 GMT

The Mayo clinics macros are here but that one isn't one that's available anymore. There's a gmatch for greedy matching and vmatch.
https://bioinformaticstools.mayo.edu/?category=20

Re: Can someone help me understand why the %match macro wont run?

Rover17 — Sat, 05 Feb 2022 20:40:44 GMT

Thanks Reeza.

I will try that later today.

However, I was under the impression that the %match macro I asked about would function the same way as the %ds2csv macro that converts SAS datasets to CSV files.

For the %ds2csv, there is no need to use the %marco and %mend statements.

For example;

Data CASES;
Input PTID AGMT CHK AGMN WT;
Cards;
101 39 1 13 118
102 35 1 14 129
103 28 1 12 108
104 31 1 14 110
105 41 1 13 138
;

%ds2csv(data=CASES, csvfile='c:\CASES.csv', runmode=b);

Why do they differ?

Regards,

Aaron

Re: Can someone help me understand why the %match macro wont run?

SASKiwi — Sun, 06 Feb 2022 00:12:56 GMT

%ds2csv is a SAS-supplied macro so is available to anyone using that SAS installation. %match appears to be a user-written macro so will only be available if the user has posted or published it so others can use it.

A macro always starts with a %MACRO statement and ends with a %MEND statement.

When you run %ds2csv, you are running a macro program that starts with the statement %MACRO ds2csv and ends with %MEND. So for %match to work you need a similar macro program,].

Re: Can someone help me understand why the %match macro wont run?

ballardw — Sun, 06 Feb 2022 08:46:41 GMT

If you run this code:

proc options option=set;run;

The log may show something like:

 SET=[FT15F001 = 'FT15F001.DAT'] [SASROOT = "C:\Program Files\SASHome\SASFoundation\9.4"]
[SASHOME = "C:\Program Files\SASHome"] [SASAUTOS = (                    "!SASROOT\core\sasmacro"
        "!SASROOT\aacomp\sasmacro"          "!SASROOT\accelmva\sasmacro"
"!SASROOT\dmscore\sasmacro"          "!SASROOT\graph\sasmacro"          "!SASROOT\hps\sasmacro"
       "!SASROOT\stat\sasmacro"          )] [SAMPSIO = (
"!SASROOT\core\sample"          "!SASROOT\access\sample"          "!SASROOT\accesssample\sample"
        "!SASROOT\graph\sample"          "!SASROOT\hps\sample"          "!SASROOT\hpstat\sample"
        "!SASROOT\stat\sample"          )] [SAMPsrc=(                    "!SASROOT\core\sample"
         "!SASROOT\access\sample"          "!SASROOT\accesssample\sample"
"!SASROOT\graph\sample"          "!SASROOT\hps\sample"          "!SASROOT\hpstat\sample"
"!SASROOT\stat\sample"          )] [INSTALL = (                    )] [MYSASFILES =
"?FOLDERID_Documents\My SAS Files\9.4"] [SASCFG = "C:\Program
Files\SASHome\SASFoundation\9.4\nls\en"] [SAS_NO_RANDOM_ACCESS = "1"]
                   Defines a SAS environment variable.

The relevant part starts at [SASAUTOS = . You will see a list of paths that end in SASMACRO (at least for the SAS supplied folders. The SASAUTOS option sets locations that your SAS install will search for macro names if the macro has not been compiled in the current session. If the macro name is found is found in any of those folders it will be compiled and made available for use.

Macro program definition files will be found in those folders with the name of the macro and SAS as an extension. Your installation might include custom macros in a location other than SAS install folders and use the option SASAUTOS in your local configuration to point to additional macros. If you macro definition code does not exist in one of the SASAUTOS folders you need to compile it for each session you expect to use the macro.

In my case the %ds2csv macro is in C:\Program Files\SASHome\SASFoundation\9.4\core\sasmacro.

@Rover17 wrote:

Thanks Reeza.

I will try that later today.

However, I was under the impression that the %match macro I asked about would function the same way as the %ds2csv macro that converts SAS datasets to CSV files.

For the %ds2csv, there is no need to use the %marco and %mend statements.

Re: Can someone help me understand why the %match macro wont run?

Rover17 — Sun, 06 Feb 2022 14:46:53 GMT

This is a great explanation on the difference between SAS supplied vs user created macros.

Regards

Re: Can someone help me understand why the %match macro wont run?

Rover17 — Sun, 06 Feb 2022 14:46:28 GMT

This is also a big help. Thanks!