ORDER=DATA option in PROC FREQ

[S_pera]

Hi

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 

[FreelanceReinh · Accepted solution]

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;

[S_pera]

Thank you very much.

S_pera