topic Re: Display the missing CLASS in Proc Tabulate in SAS Procedures

Display the missing CLASS in Proc Tabulate

Sathish_jammy — Tue, 10 Sep 2019 04:40:54 GMT

Dear Experts,

I have a table to evaluate the Sum/Count using Proc Tabulate procedure.

If the class value has (0/Null/Missing) value it omits that entire class row in the table. but I need to specify the null value too.

I'll share the code and Image for a better understanding.

proc tabulate data = Sv.SRK;
title '17) Monthly Income of Respondent';
class Monthly_Inc15 Qut2_Sex;
tables Monthly_Inc15 all, (Qut2_Sex *(n*f=8. colpctn='%')) all='Total'*(n*f=8. reppctn='%')/rts=10;
run;

In the given table

80,001 - 1,00,000

1,00,001 - 1,25,000

1,25,001 - 1,50,000

1,50,001 - 1,75,000

till 2,75,000 class value is missed.

I want to display the gender values like 0 for the missed Monthly_Inc value.

Kindly suggest some ideas to solve the task.

Thanks in advance!

Re: Display the missing CLASS in Proc Tabulate

andreas_lds — Tue, 10 Sep 2019 05:30:57 GMT

Have you tried using the missing option?

Re: Display the missing CLASS in Proc Tabulate

Sathish_jammy — Tue, 10 Sep 2019 06:39:31 GMT

@andreas_lds Tried, But that doesn't work

Re: Display the missing CLASS in Proc Tabulate

andreas_lds — Tue, 10 Sep 2019 06:43:41 GMT

ok, can you post an excerpt of the data you have?

Re: Display the missing CLASS in Proc Tabulate

Ksharp — Tue, 10 Sep 2019 11:43:06 GMT

proc tabulate data = Sv.SRK;
title '17) Monthly Income of Respondent';
class Monthly_Inc15 Qut2_Sex / missing ;
tables Monthly_Inc15 all, (Qut2_Sex *(n*f=8. colpctn='%'))
all='Total'*(n*f=8. reppctn='%')/rts=10 printmiss ;
run;

Re: Display the missing CLASS in Proc Tabulate

Ksharp — Tue, 10 Sep 2019 11:44:12 GMT

class Monthly_Inc15 / missing ;

class Qut2_Sex / missing ;

Re: Display the missing CLASS in Proc Tabulate

ballardw — Tue, 10 Sep 2019 14:38:09 GMT

You may be looking for PRELOADFMT along with the class option missing and the table option Printmiss.

If your class variable doesn't have a format currently applied you may need to create one for use in the table.