topic Re: Convert into a macro that will produce either the frequency report or the descriptive statistics in SAS Programming

Convert into a macro that will produce either the frequency report or the descriptive statistics

mrahouma — Sat, 16 Nov 2019 22:46:33 GMT

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.

Re: Convert into a macro that will produce either the frequency report or the descriptive statistics

SASKiwi — Sat, 16 Nov 2019 22:57:10 GMT

There are at least two problems with your code. You need commas between macro parameters in your MACRO statement and when you call it:

%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);

Re: Convert into a macro that will produce either the frequency report or the descriptive statistics

mrahouma — Sat, 16 Nov 2019 22:59:07 GMT

It works . Thanks a lot.

Re: Convert into a macro that will produce either the frequency report or the descriptive statistics

mrahouma — Sat, 16 Nov 2019 23:57:40 GMT

@SASKiwi Is there a way to A) add a parameter to the macro that can control which variable is used for the report and 2) 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)? Sorry for overloading.

Re: Convert into a macro that will produce either the frequency report or the descriptive statistics

SASKiwi — Sun, 17 Nov 2019 00:53:42 GMT

@mrahouma - I'm not sure what you mean by "add a parameter to the macro that can control which variable is used for the report". If you could post where this variable would go in your code, then that would make it a lot clearer. Here is an example of adding a title.

%macro freq_Describe (MNTH=month, AIR_Temp=AirTemp, MyTitle =  );
/*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 ;
title1 "&MyTitle";
 var &AIR_Temp.; run;
%mend freq_Describe;

%freq_Describe (MNTH=month, AIR_Temp=AirTemp, MyTitle = Air Temperatures);

Re: Convert into a macro that will produce either the frequency report or the descriptive statistics

mrahouma — Sun, 17 Nov 2019 01:15:32 GMT

Thanks a lot for your follow-up reply. Assuming after preparation of our macro , we need to get one of the two included variable (i.e. month or airTemp only ). Consequently we need to edit the results to convey that. I tried to see if the current macro can give the results of 1 variable eg month but it doesn't. Any advice will be greatly appreciated.

Re: Convert into a macro that will produce either the frequency report or the descriptive statistics

SASKiwi — Sun, 17 Nov 2019 02:01:49 GMT

Please provide an example of the data you have and the expected output you want.