topic macro in SAS Programming

macro

manya92 — Tue, 02 Oct 2018 22:11:51 GMT

hi all,

I wanted to ask how can edit this code to run without error

%macro count_pt ;

	proc sql;
		select count(distinct patient_id), count (*) 
			into:patients trimmed into:obs
		from  &syslast. ;
	quit ;
	
	%put There are &patients. and &obs. from &syslast. ; 
	
%mend count_pt ;
%count_pt;

Re: macro

Astounding — Tue, 02 Oct 2018 22:15:53 GMT

You should be able to reorganize one line:

into : patients trimmed, : obs

Re: macro

ballardw — Wed, 03 Oct 2018 16:33:05 GMT

@manya92 wrote:

hi all,

I wanted to ask how can edit this code to run without error

%macro count_pt ;

	proc sql;
		select count(distinct patient_id), count (*) 
			into:patients trimmed into:obs
		from  &syslast. ;
	quit ;
	
	%put There are &patients. and &obs. from &syslast. ; 
	
%mend count_pt ;
%count_pt;

I would be very hesitant to say a macro that relies on referencing the last created data set for input and mentioning specific variables could ever be made to run "without errors" without providing code to check that the variables used exist in the data set. At which point you may need to have some code outside of this macro to modify following code behavior when the &syslast data set does not contain the patient_id variable.