Hello, I'm a beginner using SAS university edition. I have a data set containing flight information and a variable Country. I am trying to write a macro where i could call the macro with varying values of Country as parameters, for example, %subset("US","CA") or %subset("US","AU","CH"). I tried using the PARMBUFF option but got an error  ERROR: User does not have appropriate authorization level for library WC000001. My code is %macro subsets/parmbuff; %let num=1; %let dsname=%scan(&syspbuff, &num); %do %while(&dsname ne); data &dsname; set myexcel; If country in (&dsname)then output; run; proc print data=&dsname; run; %let num=%eval(&num+1); %let dsname=%scan(&syspbuff, &num); %end; %mend subsets; %subsets("US","CA"); I would appreciate any help to point out my mistakes. thankyou ... View more

Hi all, I have recently started learning SAS was trying to create a macro but ran into an error. I have a dataset with a variable order_date which is a numeric type in mmddyy10 format and order_type which is numeric as well with values of either 1 or 2. I am trying to write a macro where, I can calculate the frequency of orders of a specific type of order in a specific year. OR lets say I only specify a year, i should get frequency of all the types of orders from that year. Also, wanted to have appropriate titles for example, "total number of orders for 2005" or "total number of type 1 orders in 2005". I am using SAS university edition. below is the code   %macro frequency(orderyr=, type= ); %if year(order_date)= &orderyr and order_type= &type %then       %do;               title"Total Type &type orders for &orderyr";               proc freq data=myexcel;               tables order_type * Quantity/norow nocol nocum nopercent;       %end; %else %if year(order_date) = &orderyr %then        %do;                title"Total Orders for all types in &orderyr";                proc freq data=myexcel;                tables order_type * quantity/norow nocol nocum nopercent;       %end; %mend frequency; run; %frequency;   this is the error :  ERROR: Required operator not found in expression: year(order_date)= &orderyr and order_type= &type  ANy help is really appreciated. Thank you ... View more