topic ORDER=DATA option in PROC FREQ in Statistical Procedures

ORDER=DATA option in PROC FREQ

S_pera — Fri, 12 Jun 2020 07:19:31 GMT

I use SAS University edition and I found ORDER=DATA option doesn't work for this program and dataset.

data trend;
input x y n;
cards;
1 1 0
1 0 5
2 1 3
2 0 3
3 1 0
3 0 1
;
proc freq order=data; weight n;
tables x*y/chisq nocol nopercent measures;
Exact trend;
run;

However, when n is different from 0 for the very first cell it works. This order is important because the exact trend is base on the first column/row. Please suggest how to make ORDER = DATA option works irrespective of the data.

rgds

S_pera

Re: ORDER=DATA option in PROC FREQ

FreelanceReinh — Fri, 12 Jun 2020 08:23:25 GMT

Hi @S_pera and welcome to the SAS Support Communities!

You need to add the ZEROS option of the WEIGHT statement. Otherwise zero-weight observations are ignored.

weight n / zeros;

Re: ORDER=DATA option in PROC FREQ

S_pera — Fri, 12 Jun 2020 09:13:31 GMT

Thank you very much.

S_pera