/style=data_date9 was a relic from an earlier version and doesn't do anything on this.  This was a quick example put together to post on here. ... View more

Bump ... View more

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

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. ... View more

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; ... View more

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. ... View more

Yeah, I'm a tabulate guy, but SAS doesn't seem to want to play nice here.  Maybe I'll have to learn REPORT for this, unless SAS wants to fix this.  ... View more

Almost.  The Vars are coming out as date style now, as well. ... View more

Same here, I get the TABLE error when I use Tagattr.     ... View more

I posted an example in the OP. ... View more

Bumping because I still have this issue. ... View more

No, I'm with you there.  The problem is that if I want to use excel formulas or graphs or anything that wants it to be a date, that doesn't work.  I can make a formula in excel that dissects the text.. ... View more