topic Re: Proc tabulate var not showing all categories in SAS Programming

Proc tabulate var not showing all categories

jogden — Tue, 23 Apr 2019 23:07:36 GMT

When I use proc tabulate it is not showing all of the categories under my variable. Here is my code:

proc tabulate data=combined ;
class obese;
var racenew;
table racenew,
obese='Obese'*(n=' '*f=comma12.0 pctsum=' '*f=pctfmt.) ;
format racenew racenew. obese obese. ;
run;

Here is a picture of what comes out:

ObesePatients with Obesity
Patients without
ObesityRace

3,168

(7.94%)

36,482

(92.06%)

I want it to show the categories of 'Race'. Ex: Race

Native American

Caucasian

African American

Re: Proc tabulate var not showing all categories

Astounding — Tue, 23 Apr 2019 23:45:07 GMT

To get the report you have shown, RACENEW must be part of the CLASS statement, not part of the VAR statement.

What are you trying to sum here? Is there some other variable that you haven't mentioned? Or do you actually need PCTN instead of PCTSUM?

Re: Proc tabulate var not showing all categories

jogden — Wed, 24 Apr 2019 17:15:34 GMT

So basically, I am wanting the Race categories to show. I am not sure how to code that though. I want it to show both 'Obese' and 'Race' categories like the above picture.

Re: Proc tabulate var not showing all categories

jogden — Wed, 24 Apr 2019 17:20:51 GMT

I just figured it out!

Here is my code:

proc tabulate data=combined ;
class obese racenew;
table racenew,
obese='Obese'*(n=' '*f=comma12.0 pctn=' '*f=pctfmt.) ;
format racenew racenew. obese obese. ;
run;