Cross Tabulation 3 categorical

[chrkim]

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 

[PaigeMiller]

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).

[chrkim]

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. 

[mkeintz · Accepted solution]

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;

[chrkim]

This worked, thank you so much!