04-11-2017 02:35 AM
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;
VAR OP CL;
TABLES O=' ',(OP='WELCOME' C='NOT WELCOME')
/ 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.
04-11-2017 10:41 AM
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