Passing Parameters in a SAS Macro -
i writing macro school assignment pass name of airline macro, sure has character strings , " , ' missing, not run. please tell me doing wrong.
%macro select airine=; proc means data=mytables.airtraffic noprint ; bosflights gt 0 , bospassengers gt 0; &airline; var bosflights bospassengers; output out=mytables.bosflightsairport sum (bosflights bospassengers)= flights passengers;` run; %mend select; %select airline = envoy air;
you missing ()
in macro definition , call.
%macro select(airline=); ... %mend select; %select(airline = envoy air);
are passing in name of variable or value of variable? way have written passing in 2 variable names envoy
, air
want use group data in airtraffic dataset.
if meant parameter value used subset data assuming have variable named airline
in dataset want body of macro.
proc means data=mytables.airtraffic noprint ; bosflights gt 0 , bospassengers gt 0; airline="&airline"; var bosflights bospassengers; output out=mytables.bosflightsairport sum(bosflights bospassengers)= flights passengers ;` run;
Comments
Post a Comment