Hi 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   ... View more

Hi all,   I need help putting in currency symbols in the salary column to the data set below:   data new; input empcode salary country $; cards; 1001 1473.33 USA 1002 1560.00 UK 1003 1646.67 india 1004 1733.33 japan 1005 1820.00 netherlands 1006 1906.67 poland 1007 1933.33 zimbabwe; run;   I was told that this could be done using PROC FORMAT. The values should still be numeric, they just need the correct currency symbols. Any help is greatly appreciated   ... View more