topic Re: Tabulate, Compound Box = ? in ODS and Base Reporting

Tabulate, Compound Box = ?

wcpatton — Thu, 23 Jan 2014 14:11:56 GMT

Anyway to get my box= to display the _page_ value, followed by something?

I.e.

_page_ & "by State"

Re: Tabulate, Compound Box = ?

wcpatton — Thu, 23 Jan 2014 15:57:09 GMT

Responding to clarify:

So if my table had two class values (state, product), I want to end up with the box (or title, I suppose) saying [product] by State.

Re: Tabulate, Compound Box = ?

Reeza — Thu, 23 Jan 2014 16:17:36 GMT

What does your proc tabulate code look like?

Re: Tabulate, Compound Box = ?

wcpatton — Thu, 23 Jan 2014 16:19:10 GMT

options missing="0";

title;

ods html file=

"I:\RSD\Reports\CROSSPRODUCT\Portfolio RSR\Output\test.xls"

STYLE=nobreak;

options nomlogic nomprint;

proc tabulate data=rsr_combine missing;

class vintage product;

var ytd_nco balance delqbal annl_nco;

tables (all='Total Credit' product=''), (vintage='' all),

ytd_nco = "YTD Net Charge-off" *sum="" * f=dollar18.0

ytd_nco = "% of Total Net C/O" * reppctsum = "" * f=pctfmt16.4

ytd_nco = "% of Product Net C/O" * pctsum<vintage all> = "" * f=pctfmt16.4

annl_nco = "% Annualized C/O Rate" * pctsum<balance> = "" * f=pctfmt16.3

balance = "Outstanding Balance" *sum="" * f=dollar18.0

balance = "% of Total O/S" * reppctsum = "" * f=pctfmt24.4

balance = "% of Product O/S" * pctsum<vintage all> = "" * f=pctfmt16.4

delqbal = "Delq Bal" *sum="" * f=dollar18.0

delqbal = "% of Total Delq" * reppctsum = "" * f=pctfmt24.4

delqbal = "% of Product Delq" * pctsum<vintage all> = "" * f=pctfmt16.4

delqbal = "Delq Rate as of &month &yyyy" * pctsum<balance> = "" * f=pctfmt36.4/

box=???;

title ;

format vintage vint.;

run;

ods html close;

Re: Tabulate, Compound Box = ?

wcpatton — Thu, 23 Jan 2014 16:19:48 GMT

Product has values like Auto, HELOC, etc.

Ideally, for this table, my box or title would say

Auto by Vintage

HELOC by Vintage

Mortgage by Vintage

etc.

Re: Tabulate, Compound Box = ?

Reeza — Thu, 23 Jan 2014 17:22:34 GMT

I was hoping the #byval would work but it doesn't seem to

Or I did something wrong.

proc sort data=sashelp.shoes out=shoes;

by region;

run;

proc tabulate data=shoes;

by region;

class product subsidiary;

var sales inventory;

table product*subsidiary, sales='Sales $'*sum=''*f=dollar12. inventory="Inventory $"*sum=""*f=dollar12./box='#byval(region)';

run;

Re: Tabulate, Compound Box = ?

wcpatton — Thu, 23 Jan 2014 17:24:27 GMT

#byval works in a title statement, but not in box= :smileyangry: