BookmarkSubscribeRSS Feed
abhityagi
Obsidian | Level 7

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.

3 REPLIES 3
Jagadishkatam
Amethyst | Level 16
Please include missing in proc tabulate like below

PROC TABULATE DATA = ABHI MISSING NOSEPS;
Thanks,
Jag
abhityagi
Obsidian | Level 7

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

ballardw
Super User

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

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1741 views
  • 1 like
  • 3 in conversation