BookmarkSubscribeRSS Feed
Sathish_jammy
Lapis Lazuli | Level 10

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;

tsab.jpg

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!

 

6 REPLIES 6
andreas_lds
Jade | Level 19

Have you tried using the missing option?

Sathish_jammy
Lapis Lazuli | Level 10

@andreas_lds  Tried, But that doesn't work

andreas_lds
Jade | Level 19

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

Ksharp
Super User

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
Super User

class Monthly_Inc15 / missing ;

class Qut2_Sex / missing ;

ballardw
Super User

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.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1599 views
  • 0 likes
  • 4 in conversation