topic Re: Proc tabulate empty data in SAS Programming

Proc tabulate empty data

abhityagi — Tue, 11 Apr 2017 06:35:03 GMT

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.

Jagadishkatam — Tue, 11 Apr 2017 07:10:17 GMT

Please include missing in proc tabulate like below

PROC TABULATE DATA = ABHI MISSING NOSEPS;

abhityagi — Tue, 11 Apr 2017 09:35:44 GMT

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

ballardw — Tue, 11 Apr 2017 14:41:13 GMT

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