macros

[manya92]

Thank You

[Tom]

If you want to make the macro more flexible add parameters.  You can include logic to add a default value. 

You can have SAS add the default value for you if you make the parameters non-positional.

%macro patient_obs(dsn=&syslast);
....
  from &dsn 
....
%mend ;

Or you can add your own logic.

%macro patient_obs(dsnt);
%if 0=%length(&dsn) %then %let dsn=&syslast;
%if not %sysfunc(exist(&dsn)) %then %do;
  %put &=dsn not found.;
%end;
....
  from &dsn 
....
%mend ;

[manya92]

in this code  :- what is INTO:npatients trimmed nobs trimmed for ? i dont know what trimmed means in this case

%macro patient_obs() ;
%global nobs npatients ;
proc sql noprint;
  select
         count(enrolid) format=32.
       , count(N) format=32.
    into 
         :npatients trimmed 
       , :nobs trimmed
  from &syslast. 
  ;
quit ;
%put Dataset &syslast. has &nobs. observations and &npatients. patients ;
%mend patient_obs;

[Tom]

Apparently the new SAS 9.4 documentation is defective.

Look at the SAs 9.3 documentation instead.

INTO clause