topic Re: PROC Freq by descending issue in New SAS User

PROC Freq by descending issue

pramenon1 — Thu, 08 Jul 2021 16:40:36 GMT

Hi, I am trying to create a 2x2 table and gather chisq. However, my treatment variable is by default showing up as 2 then 1 but i wanted it in ascending (1 then 2). My response variable is outputting correctly (1 then 0).

Here is my code:

PROC SORT data = dtanl.hivcancerdta;
by descending cancer;
RUN;

PROC FREQ data = dtanl.hivcancerdta order = data;
TABLE alcoh*cancer / chisq riskdiff or;
WHERE alcoh ^= 9;
RUN;

My output is:

Any information on what i am doing wrong would be appreciated!

Thanks!

Re: PROC Freq by descending issue

PaigeMiller — Thu, 08 Jul 2021 16:45:27 GMT

Use ORDER=INTERNAL

Re: PROC Freq by descending issue

pramenon1 — Thu, 08 Jul 2021 16:50:14 GMT

When I do that, cancer reverts to 0 then 1. I need it to be 1 then 0.

Re: PROC Freq by descending issue

FreelanceReinh — Thu, 08 Jul 2021 16:58:48 GMT

Hi @pramenon1,

Add alcoh to the BY statement of the PROC SORT step:

by alcoh descending cancer;

Then your existing ORDER=DATA will sort rows and columns of the frequency table as desired.

Re: PROC Freq by descending issue

pramenon1 — Thu, 08 Jul 2021 17:04:32 GMT

Thank you! This worked perfectly!