Display the missing CLASS in Proc Tabulate

[Sathish_jammy]

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!

[andreas_lds]

Have you tried using the missing option?

[Sathish_jammy]

@andreas_lds  Tried, But that doesn't work

[andreas_lds]

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

[Ksharp]

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;

[Ksharp]

class Monthly_Inc15 / missing ;

class Qut2_Sex / missing ;

[ballardw]

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.