topic proc reprot in SAS Programming

proc reprot

yonib — Sun, 08 Nov 2009 08:52:22 GMT

Hi ,
I build this proc report :

ods html file="\\risuilt\home\sas\MISHNE_LIFE\demografic.html";
proc report data=aaa nowindows out=t;
title demografic period;
column age gender, count ;
define age/group;
define gender/across format=$H_GENDER8.;
define count/sum format=comma12.;
run;
quit;
ods html close;

Some of the result is:

male female
age 1 . 15

im trying to change the nulls to zero

any suggestions?

Re: proc reprot

sbb — Sun, 08 Nov 2009 16:06:06 GMT

Explore the SAS OPTIONS MISSING= parameter.

Scott Barry
SBBWorks, Inc.

Re: proc reprot

yonib — Mon, 09 Nov 2009 10:34:05 GMT

Thanks Scott , i will check it !

Re: proc reprot

data_null__ — Mon, 09 Nov 2009 12:03:58 GMT

While the missing option will probabaly suffice in this situation you would be better served by the PROC REPORT option COMPLETEROWS.

[pre]
proc report nowd list headline data=sashelp.class completerows;
columns age sex, n;
define age / group;
define sex / across;
run;
[/pre]