i have created a dataset of about 100 obs out of an external file and i used the proper format/informat to read and write the values of "account"
bank_name account
BMO $1,000,000
TD $2,000,000
RBC $23,000,000
..........................
..............................
when i use rbreak after in my proc report the total of "account" does not get formatted properly. I get something like $350000000.So what happened to the comma ?
Can i format the totals of each column after the rbreak?
Please advise
Please try ,
data have;
input name$ account dollar11.;
format account dollar11.;
cards;
BMO $1,000,000
TD $2,000,000
RBC $23,000,000
;
proc report data=have out=new headline headskip;
column name account;
define name / width=20 ;
define account/ width=30;
rbreak after / summarize dol;
run;
Thanks,
Jagadish
Please try ,
data have;
input name$ account dollar11.;
format account dollar11.;
cards;
BMO $1,000,000
TD $2,000,000
RBC $23,000,000
;
proc report data=have out=new headline headskip;
column name account;
define name / width=20 ;
define account/ width=30;
rbreak after / summarize dol;
run;
Thanks,
Jagadish
thanks Jagadishkatam
so i changed the format from dollar11. to dollar12. since the total of account was exceeding 11
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.