topic Cross Tabulation 3 categorical in SAS Programming

Cross Tabulation 3 categorical

chrkim — Mon, 15 Apr 2024 21:24:05 GMT

Hello,

I am hoping to figure out frequency of a categorical outcome by 2 other categorical variables.

Rates of HTN by education and income

I want it to look like this

Frequency of HTN

Education	Income
<12	Low	Middle	High
12
12+

@sasasf

Re: Cross Tabulation 3 categorical

PaigeMiller — Mon, 15 Apr 2024 21:43:23 GMT

We don't know what HTN is. But more importantly, we need to see how your raw data is arranged. Some data set arrangements make this easy, other arrangements take a bit of extra programming to get the desired table. So please show us a portion of your actual (or fake) data in its actual arrangement, but this is important — you must provide the data as working SAS data step code (examples and instructions).

Re: Cross Tabulation 3 categorical

chrkim — Mon, 15 Apr 2024 23:53:12 GMT

Hi Thank you for your response.

I think I figured out the structure of the code using proctab.

HTN is categorical - yes = 1 and no =0

proc format;

picture pctf (round) other = '009.9%';

run;

proc tabulate data=data1;
class educ income HTN
tables educ * (HTN *(n pctn*f=pctf.)), (income all);
run;

BUT I want the frequency of HTN (as an outcome) PER education category (i.e. column percentage but for each category of education) -- pctn or colpctn give me the percentage or column percentage for ALL the education categories.

Re: Cross Tabulation 3 categorical

mkeintz — Tue, 16 Apr 2024 00:39:01 GMT

Untested, in the absence of sample data in the form of a working DATA step:

proc tabulate data=data1;
  class educ income HTN;
  tables   educ * (HTN *(n pctn<htn>*f=pctf.))
         , (income all); 
run;

Re: Cross Tabulation 3 categorical

chrkim — Fri, 19 Apr 2024 13:06:04 GMT

This worked, thank you so much!