This
example uses PROC PRINTTO to route procedure output
to an external file and then uses that file as input to a DATA step.
 |
data test;
do n=1 to 1000;
x=int(ranuni(77777)*7);
y=int(ranuni(77777)*5);
output;
end;
run; |
| |
filename routed 'output-filename'; |
proc printto print=routed new;
run;
| |
proc freq data=test;
tables x*y / chisq;
run; |
| |
proc printto print=print;
run; |
| |
data probtest;
infile routed;
input word1 $ @;
if word1='Chi-Squa' then
do;
input df chisq prob;
keep chisq prob;
output;
end;
run; |
| |
proc print data=probtest;
title 'Chi-Square Analysis for Table of X by Y';
run; |
PROC FREQ Output Routed to the External File Referenced as ROUTED
The FREQ Procedure
Table of x by y
x y
Frequency|
Percent |
Row Pct |
Col Pct | 0| 1| 2| 3| 4| Total
---------+--------+--------+--------+--------+--------+
0 | 29 | 33 | 12 | 25 | 27 | 126
| 2.90 | 3.30 | 1.20 | 2.50 | 2.70 | 12.60
| 23.02 | 26.19 | 9.52 | 19.84 | 21.43 |
| 15.18 | 16.18 | 6.25 | 11.74 | 13.50 |
---------+--------+--------+--------+--------+--------+
1 | 23 | 26 | 29 | 20 | 19 | 117
| 2.30 | 2.60 | 2.90 | 2.00 | 1.90 | 11.70
| 19.66 | 22.22 | 24.79 | 17.09 | 16.24 |
| 12.04 | 12.75 | 15.10 | 9.39 | 9.50 |
---------+--------+--------+--------+--------+--------+
2 | 28 | 26 | 32 | 30 | 25 | 141
| 2.80 | 2.60 | 3.20 | 3.00 | 2.50 | 14.10
| 19.86 | 18.44 | 22.70 | 21.28 | 17.73 |
| 14.66 | 12.75 | 16.67 | 14.08 | 12.50 |
---------+--------+--------+--------+--------+--------+
3 | 26 | 24 | 36 | 32 | 45 | 163
| 2.60 | 2.40 | 3.60 | 3.20 | 4.50 | 16.30
| 15.95 | 14.72 | 22.09 | 19.63 | 27.61 |
| 13.61 | 11.76 | 18.75 | 15.02 | 22.50 |
---------+--------+--------+--------+--------+--------+
4 | 25 | 31 | 28 | 36 | 29 | 149
| 2.50 | 3.10 | 2.80 | 3.60 | 2.90 | 14.90
| 16.78 | 20.81 | 18.79 | 24.16 | 19.46 |
| 13.09 | 15.20 | 14.58 | 16.90 | 14.50 |
---------+--------+--------+--------+--------+--------+
5 | 32 | 29 | 26 | 33 | 27 | 147
| 3.20 | 2.90 | 2.60 | 3.30 | 2.70 | 14.70
| 21.77 | 19.73 | 17.69 | 22.45 | 18.37 |
| 16.75 | 14.22 | 13.54 | 15.49 | 13.50 |
---------+--------+--------+--------+--------+--------+
6 | 28 | 35 | 29 | 37 | 28 | 157
| 2.80 | 3.50 | 2.90 | 3.70 | 2.80 | 15.70
| 17.83 | 22.29 | 18.47 | 23.57 | 17.83 |
| 14.66 | 17.16 | 15.10 | 17.37 | 14.00 |
---------+--------+--------+--------+--------+--------+
Total 191 204 192 213 200 1000
19.10 20.40 19.20 21.30 20.00 100.00
2
The FREQ Procedure
Statistics for Table of x by y
Statistic DF Value Prob
------------------------------------------------------
Chi-Square 24 27.2971 0.2908
Likelihood Ratio Chi-Square 24 28.1830 0.2524
Mantel-Haenszel Chi-Square 1 0.6149 0.4330
Phi Coefficient 0.1652
Contingency Coefficient 0.1630
Cramer's V 0.0826
Sample Size = 1000
PROC PRINT Output of Data Set PROBTEST, Routed to Default Destination
Chi-Square Analysis for Table of X by Y 3
Obs chisq prob
1 27.297 0.291
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
