proc report

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 440
Accepted Solution

proc report

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


Accepted Solutions
Solution
‎11-23-2013 10:26 PM
Trusted Advisor
Posts: 1,128

Re: proc report

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,
Jag

View solution in original post


All Replies
Solution
‎11-23-2013 10:26 PM
Trusted Advisor
Posts: 1,128

Re: proc report

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,
Jag
Super Contributor
Super Contributor
Posts: 440

Re: proc report

thanks Jagadishkatam

so i changed the format from dollar11. to dollar12. since the total of account was exceeding 11

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 157 views
  • 0 likes
  • 2 in conversation