DATA Step, Macro, Functions and more

Proc tabulate empty data

Reply
Occasional Contributor
Posts: 12

Proc tabulate empty data

Hi,

 

I am getting given below warning in proc tabulate. Can any one help me to fix this warnning. 

 

"WARNNING : A LOGICAL PAGE CONTAINING ONLY MISSING VALUES HAS BEEN DELETED"

 

See the given below source :

PROC TABULATE DATA = ABHI NOSEPS;
CLASS O;
VAR OP CL;
TABLES O=' ',(OP='WELCOME' C='NOT WELCOME')
*SUM=''*F=COMMA12.
/ BOX='O' RTS=10;

 

note : the reason behind this warning is OP and CL have no data(NULL values)

 

Please help me if we can find the way to overcome this warrning or we can make a OP and CL values 0, 0 for both. It will be really helpful.

Trusted Advisor
Posts: 1,137

Re: Proc tabulate empty data

Posted in reply to abhityagi
Please include missing in proc tabulate like below

PROC TABULATE DATA = ABHI MISSING NOSEPS;
Thanks,
Jag
Occasional Contributor
Posts: 12

Re: Proc tabulate empty data

Posted in reply to Jagadishkatam

Thanks for your quick response. But Adding 'MISSING' in Proc tabulate could not resolved the warnning issue. Warnning will be stil there.

Super User
Posts: 11,343

Re: Proc tabulate empty data

Posted in reply to abhityagi

Do you want to suppress the message or create a table?

If you want a table provide some example data, in the form of a data step, and what the table should look like.

 

The only way that should be happening if OP and CL are missing for every single value of O. In which case what do you expect?

 

If you already know that all the values are missing then try:

 

PROC TABULATE DATA = junk ;
CLASS O /missing;

VAR OP CL;
TABLES O=' ',(OP='WELCOME' Cl='NOT WELCOME')
*n=''*F=COMMA12.
/ BOX='O' ;
run;

SUM expects at least one none missing value, N isn't quite so picky

 

Ask a Question
Discussion stats
  • 3 replies
  • 165 views
  • 1 like
  • 3 in conversation