I want to create a sas macro  so that it can be run for any airport. to calculate sum flights and sum passenger per that airport I want to call the macro once for each of the 12 airports. Please note that all airports names consist of 3 letters. ... View more

I coverted a regular code (below)  into a macro that will produce either the frequency report or the descriptive statistics report based on a value of a parameter that is passed to the macro.*/;   Original code /*frequency report for month*/; proc means data=VIRGINIAKEY N ; var month; class month;run; /*lists basic descriptive statistics (N, mean, standard deviation, minimum, and maximum) for air temperature*/; proc means data=VIRGINIAKEY ; var AirTemp; run; Myy Current trial code: %macro freq_Describe (MNTH=month, AIR_Temp=AirTemp ); /*frequency report for month*/; proc means data=VIRGINIAKEY N ; var &MNTH.; class &MNTH.;run; /*lists basic descriptive statistics (N, mean, standard deviation, minimum, and maximum) for air temperature*/; proc means data=VIRGINIAKEY ; var &AIR_Temp.; run; %mend freq_Describe; %freq_Describe (MNTH=month , AIR_Temp=AirTemp);     Is there a way to A) add a parameter to the macro that can control which variable is used for the report and   B) add titles that reflect the type of report (frequency or descriptive statistics) including a short description of the variable (specifying the description of the variable as a parameter for the macro)?   Any advice will be appreciated. ... View more

I want to covert a regular code (below)  into a macro that will produce either the frequency report or the descriptive statistics report based on a value of a parameter that is passed to the macro.*/;   Original code /*frequency report for month*/; proc means data=VIRGINIAKEY N ; var month; class month;run; /*lists basic descriptive statistics (N, mean, standard deviation, minimum, and maximum) for air temperature*/; proc means data=VIRGINIAKEY ; var AirTemp; run; Myy Current trial code: %macro freq_Describe (MNTH=month AIR_Temp=AirTemp ); /*frequency report for month*/; proc means data=VIRGINIAKEY N ; var &MNTH.; class &MNTH.;run; /*lists basic descriptive statistics (N, mean, standard deviation, minimum, and maximum) for air temperature*/; proc means data=VIRGINIAKEY ; var &AIR_Temp.; run; %mend freq_Describe; %freq_Describe (MNTH=month ; AIR_Temp=AirTemp); usiing my trial code, I got several errors NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds       NOTE: Line generated by the invoked macro "FREQ_DESCRIBE". 81 proc means data=VIRGINIAKEY ; var &AIR_Temp.; run; _ 22 200 WARNING: Apparent symbolic reference AIR_TEMP not resolved.   ERROR 22-322: Syntax error, expecting one of the following: a name, ;, /, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.   ERROR 200-322: The symbol is not recognized and will be ignored.   NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.01 seconds   NOTE: Line generated by the macro variable "MNTH". 81 month ; AIR_Temp=AirTemp ________ 180 NOTE: Line generated by the macro variable "MNTH". 81 month ; AIR_Temp=AirTemp ________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 82 83 84 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 96 Any advice will be greatly appreciated. ... View more

I have the following dataset   data orders; input customerid OrderDate DATE7. Model $13-24 Quantity; cards; 287 15OCT03 Dealr Breeze 15 287 15OCT03 Sarah Ana 15 274 16OCT03 Gee Stream 1 174 17OCT03 Sarah Ana 20 174 17OCT03 Nor'easter 5 174 17OCT03 Scirocco 1 347 18OCT03 Mistral 1 287 21OCT03 Dealr Breeze 30 287 21OCT03 Gee Ana 25 ; run;       I want to write a macro called pick_order that will print a subset of the data set orders for a selected customer---> So I wrote the following code;   %macro pick_order (id=); proc print data=Orders noobs; where customerid = "&id.";  title "&id. Orders"; run; %mend pick_order; *THEN I want to run my macro I have written to print the table for customer 287; %pick_order (id=287);     I got the following error: ERROR: WHERE clause operator requires compatible variables.   Any advie will be greatly appreciated. ... View more

I need to Use SAS random number generation functions `RAND()` and a `DO....END loop` to create 100 obs in variable named X then I want to use another DO loop of 500 rounds to generate a total of 500 samples, each with 100 obs. a sample is basically sampling from a standard normal distribution. I tried the following code but it does not give me what I need:   data A; call streaminit(123); /* set random number seed */ do i = 1 to 100; X = rand("Normal"); /* random number generator */ output; end; do r = 1 to 500 ; if i then X = rand("Normal"); output; end; run;   Any input will be greatly appreciated. ... View more

I have the following dataset from which I need help to extract middle name from heterogeneous variable with different words count. I saw prior link but it does not work for me. my data has only 1 variable   Data statisticians; infile datalines ; Input name $30. ; Datalines; Ronaldo Al Fisher H. O. Meir Lee Sara Kim Ivan Marco Sina ; run;     Names with first and last names only should be blank in the new column called middle. I tried the following code but it does not work: data statisticians;  length middle $10; set statisticians; if count = 2 then middle=.; if count = 3 then middle= scan(name,2); if count = 4 then middle=scan(name,2);  run; Any help will be greatly appreciated.   ... View more