This macro encapsulates the `PROC FREQ` procedure to perform Chi-square tests (2x2 or larger contingency tables). It offers parameters to specify variables, the source table, test options (including exact tests), and output tables. The script also includes cleaning of intermediate results and display via `PROC PRINT`.
Data Analysis
Type : MIXED
The macro operates on an input table specified by the `dsn` parameter. The documentation example suggests using `sashelp.bmt`.
1 Code Block
MACRO DEFINITION Data
Explanation :
Definition of the `%chisq` macro. It temporarily disables listing output (`ods listing close`), executes `PROC FREQ` with the specified options to generate result tables (`CrossTabFreqs`, `ChiSq`), cleans the frequency table via a `DATA STEP` to remove technical columns, then re-enables listing output and prints the final results.
Definition of the `%chisq` macro. It temporarily disables listing output (`ods listing close`), executes `PROC FREQ` with the specified options to generate result tables (`CrossTabFreqs`, `ChiSq`), cleans the frequency table via a `DATA STEP` to remove technical columns, then re-enables listing output and prints the final results.
Copied!
| 1 | %macro chisq(vars, dsn, tests=chisq, outFreq=NULL, outChi=tmp, |
| 2 | order=freq, testOpt=, where=, BY=); |
| 3 | |
| 4 | * Close output to listing file/log; |
| 5 | ods listing close; |
| 6 | PROC FREQ DATA=&dsn order=ℴ |
| 7 | tables &vars / chisq &testOpt; |
| 8 | exact &tests ; |
| 9 | where &where; |
| 10 | BY &BY; |
| 11 | * Output results into a dataset; |
| 12 | ods OUTPUT CrossTabFreqs=&outFreq ChiSq=&outChi; |
| 13 | RUN; |
| 14 | ods listing; |
| 15 | |
| 16 | * Remove some extraneous variables; |
| 17 | DATA &outFreq; |
| 18 | SET &outFreq (drop=_TYPE_ _TABLE_); |
| 19 | RUN; |
| 20 | |
| 21 | * Print the results; |
| 22 | PROC PRINT DATA=&outFreq; |
| 23 | RUN; |
| 24 | PROC PRINT DATA=&outChi; |
| 25 | RUN; |
| 26 | %mend chisq; |
This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.
Copyright Info : Luke Johnston
