DATA Step, Macro, Functions and more

proc reprot

Reply
SAS Employee
Posts: 105

proc reprot

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?
Super Contributor
Super Contributor
Posts: 3,174

Re: proc reprot

Explore the SAS OPTIONS MISSING= parameter.

Scott Barry
SBBWorks, Inc.
SAS Employee
Posts: 105

Re: proc reprot

Thanks Scott , i will check it !
Respected Advisor
Posts: 3,777

Re: proc reprot

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]
Ask a Question
Discussion stats
  • 3 replies
  • 119 views
  • 0 likes
  • 3 in conversation