Hello - I seached for documentation on how to properly create the sum of a variable using the RBREAK function. I can't seem to find the right syntax. All I want to do is show a summation for the column titled "CurrBal". Can someone show/point me to documentation that shows how to properly do so.
Thanks for the guidiance.
/*CODE BELOW*/
proc report data = CML.Final_&ReportDate. nowd missing; where Product_Name like '%HYBRID%'; Column OpenDateDT Acct CustomerName CurrBal Product_Name Org_Level_02 Org_Level_03 Org_Level_04 Org_Level_05 Org_Level_06; label OpenDateDT = 'Open Date'; DEFINE Acct / STYLE(COLUMN)=[CELLWIDTH=115PX TEXTALIGN=r tagattr="format:@"]; DEFINE OpenDateDT / STYLE(COLUMN)=[CELLWIDTH=125PX TEXTALIGN=l tagattr='type:DateTime format:mm/dd/yyyy']; DEFINE Product_Name / STYLE(COLUMN)=[CELLWIDTH=250PX TEXTALIGN=l]; DEFINE CustomerName / STYLE(COLUMN)=[CELLWIDTH=400PX TEXTALIGN=l]; DEFINE Org_Level_02 / STYLE(COLUMN)=[CELLWIDTH=250PX TEXTALIGN=l]; DEFINE Org_Level_03 / STYLE(COLUMN)=[CELLWIDTH=400PX TEXTALIGN=l]; DEFINE Org_Level_04 / STYLE(COLUMN)=[CELLWIDTH=400PX TEXTALIGN=l]; DEFINE Org_Level_05 / STYLE(COLUMN)=[CELLWIDTH=500PX TEXTALIGN=l]; DEFINE Org_Level_06 / STYLE(COLUMN)=[CELLWIDTH=400PX TEXTALIGN=l]; run;
Balance
$50,000,000.00
$32,515,368.16
$18,003,846.79
$15,007,005.27
$14,742,712.88
$10,000,890.41
$5,002,123.52
$2,459,806.99
$1,502,804.41
$1,005,426.95
$1,000,816.70
$603,445.59
$0.00
$151,844,247.67 (missing summation value that I want the report to calculate)
... View more