The SAS Output Delivery System and reporting techniques

Tabulate, Compound Box = ?

Reply
Contributor
Posts: 61

Tabulate, Compound Box = ?

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

I.e.

_page_ & "by State"

Contributor
Posts: 61

Re: Tabulate, Compound Box = ?

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.

Grand Advisor
Posts: 17,420

Re: Tabulate, Compound Box = ?

What does your proc tabulate code look like?

Contributor
Posts: 61

Re: Tabulate, Compound Box = ?

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;

Contributor
Posts: 61

Re: Tabulate, Compound Box = ?

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.

Grand Advisor
Posts: 17,420

Re: Tabulate, Compound Box = ?

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

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;

Contributor
Posts: 61

Re: Tabulate, Compound Box = ?

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

Ask a Question
Discussion stats
  • 6 replies
  • 622 views
  • 0 likes
  • 2 in conversation