topic how to use proc report to generate repors with float and integer in ODS and Base Reporting

how to use proc report to generate repors with float and integer

walterwang — Fri, 05 Oct 2018 02:53:46 GMT

number	year1	year2	year3	year4
Males	6,621	7,076	7,194	7,135
Females	5,047	5,530	5,426	5,495
Persons(d)	11,668	12,606	12,620	12,630
Rate
Males	2.3	2.4	2.2	2.4
Females	2.0	2.0	2.2	2.3
Persons(d)	2.1	2.2	2.2	2.3

How should I format the output?

Re: how to use proc report to generate repors with float and integer

Reeza — Fri, 05 Oct 2018 03:10:23 GMT

I *think* you can add a grouping variable and then conditionally format the lines using a COMPUTE statement.

@walterwang wrote:

number year1 year2 year3 year4

Males 6,621 7,076 7,194 7,135

Females 5,047 5,530 5,426 5,495

Persons(d) 11,668 12,606 12,620 12,630

Rate

Males 2.3 2.4 2.2 2.4

Females 2.0 2.0 2.2 2.3

Persons(d) 2.1 2.2 2.2
2.3

How should I format the output?

Re: how to use proc report to generate repors with float and integer

walterwang — Fri, 05 Oct 2018 03:45:33 GMT

proc report nowd data=sashelp.class;

col name sex age weight height;

compute height;

if sex='F' then do;

do i = 3 to 5;

call define(i,'format','dollar8.2');

end;

endcomp;

run;