BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,

In a proc report the data is all missing. I would like to show it also as missing, but in the total at the end of the proc report. I would like to show a '0' instead of missing.

How do I do this?

Thierry
3 REPLIES 3
Olivier
Pyrite | Level 9
Hi Thierry.
You just have to add a COMPUTE block to your report procedure to "correct" the sum after computing.
[pre]
DATA work.test ;
SET sashelp.class ;
dummyVar = . ;
RUN ;
PROC REPORT DATA = work.test NOWD ;
COLUMNS _ALL_ ;
DEFINE dummyVar / ANALYSIS SUM ;
RBREAK AFTER / SUMMARIZE ;
COMPUTE AFTER ;
dummyVar.sum = COALESCE(dummyVar.sum, 0) ; /* if you're using SAS 9 */
/* IF MISSING(dummyVar.sum) THEN dummyVar.sum = 0 ; */ /* in previous versions */
ENDCOMP ;
RUN ;
[/pre]
Regards.
Olivier
deleted_user
Not applicable
Hi Oliver,

This works great!!!
Thanks alot!

Thierry
Cynthia_sas
SAS Super FREQ
Hi, Olivier:
That's a good solution. This is another that doesn't require a compute block, only MISSING in the PROC REPORT statement:
[pre]
DATA work.test ;
SET sashelp.class ;
dummyVar = . ;
RUN ;

options missing=0;

PROC REPORT DATA = work.test NOWD missing;
COLUMNS _ALL_ ;
DEFINE dummyVar / ANALYSIS SUM ;
RBREAK AFTER / SUMMARIZE ;
RUN ;

options missing=.;
[/pre]

There's usually more than one way to do something in SAS!
cynthia

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
  • 604 views
  • 0 likes
  • 3 in conversation