topic Re: Including Data Values in ODS Contents= statements in ODS and Base Reporting

Including Data Values in ODS Contents= statements

Earl_W — Mon, 17 May 2010 19:35:31 GMT

Hi,

I have a report that breaks on change of value of a column, e.g.

proc report data=xxx contents='Some Report';
columns category x y;
define category / order ...;
define x / display ...;
define y / display ...;
break before category / page contents=value-of-category;
run;

Is this possible? I could make category a BY variable, but this way would be cool to do.

Earl

Re: Including Data Values in ODS Contents= statements

David_SAS — Mon, 17 May 2010 20:52:55 GMT

Earl,

You cannot do what you want with PROC REPORT. You can do it with
PROC TABULATE by specifying your class (categorical) variables in the TABLE
statement page dimension.

-- David Kelley, SAS

Re: Including Data Values in ODS Contents= statements

Cynthia_sas — Mon, 17 May 2010 21:25:48 GMT

Hi:
BY groups will do it for you in PROC REPORT, however.
cynthia
[pre]
proc sort data=sashelp.shoes out=shoes;
by product region;
where product in ('Boot', 'Sandal');
run;

ods pdf file='c:\temp\test_contents.pdf';
ods proclabel 'Some Report';
proc report data=shoes nowd contents='';
by product;
columns product region sales returns;
define product / group ;
define region / group;
define sales / sum ;
define returns / sum ;
break before product / contents='' page;
run;
ods pdf close;
[/pre]

Re: Including Data Values in ODS Contents= statements

Earl_W — Tue, 18 May 2010 14:57:12 GMT

Thanks, David and Cynthia. I went with the BY variables. Looks great.

Earl