topic Re: Need help with Macro Do Loop and Proc Report in SAS Programming

Need help with Macro Do Loop and Proc Report

rishabhns — Wed, 26 Aug 2020 14:06:23 GMT

I'm trying to create make a Macro Do Loop that will create individual reports like the one attached for the Proc Print procedure. But every time I run the code below, it just gets put into the log but no results are printed:

%macro patients;
%do i=1101 %to i=1109;
proc report data=Report3.Clinical3Sort nofs;
where PATIENT_ID=&i.;
title "Blood Pressure Med Study";
column PATIENT_ID DRUG SEX VISIT_DATE SYSTOLIC DIASTOLIC FEVER NAUSEA RASH;
define PATIENT_ID / group;
define DRUG / group;
define SEX / group;
define VISIT_DATE / display;
define SYSTOLIC / display;
define DIASTOLIC / display;
define FEVER / display;
define NAUSEA / display;
define RASH / display;
run;
%end;
%mend;

%patients;

Any help is appreciated

Re: Need help with Macro Do Loop and Proc Report

mkeintz — Wed, 26 Aug 2020 14:21:26 GMT

You don't need a macro for this - just a BY PATIENT_ID statement. If your dataset Report3.Clinical3Sort is already sorted by ID, you can just do this:

proc report data=Report3.Clinical3Sort nofs;
  by PATIENT_ID;
  where patient_id between 1101 and 1109;
  title "Blood Pressure Med Study";
  column PATIENT_ID DRUG SEX VISIT_DATE SYSTOLIC DIASTOLIC FEVER   NAUSEA RASH;
  define PATIENT_ID / group;
  define DRUG / group;
  define SEX / group;
  define VISIT_DATE / display;
  define SYSTOLIC / display;
  define DIASTOLIC / display;
  define FEVER / display;
  define NAUSEA / display;
  define RASH / display;
run;

And if the data aren't sorted by ID, just create a sorted dataset to submit to proc report:

proc sort data=Report3.Clinical3Sort  out=temp;
  where patient_id between 1101 and 1109;
  by patient_id;
run;

proc report data=temp  nofs;
  by patient_id;
.......
run;

Re: Need help with Macro Do Loop and Proc Report

ballardw — Wed, 26 Aug 2020 14:48:30 GMT

The log showing submitted lines but no results is a typical behavior after some of the common syntax errors when learning the macro language. Creating something with unbalanced quotes, parentheses, or improperly ended statements can place the system into an unsteady state.

You likely have to close the SAS session and restart.

I would suggest that until you get experience with the macro language that you always set OPTIONS MPRINT; before running any macro and then reading the log closely. Almost any warning is something to be investigated. Also with MPRINT on then any messages appear in better relation to the issue instead of a series of notes at the end of the macro execution.