topic Re: proc report-Display values in millions instead of thousands in SAS Programming

proc report-Display values in millions instead of thousands

Ronein — Wed, 08 Aug 2018 06:50:19 GMT

Hello
I want to display values in millions.
The row data is displayed in thousands.
for example: value 1000 is 1 million, value 2000 is 2 million....
I want that the summary table of proc report will display values(sum ) in millions.

Data tbl;
input ID Team $ y;
cards;
1 a  1000
2 a  2000
3 a  3000
4 b  4000
5 b  5000
;
run;

proc report data=tbl nowd;
  column Team y ;
  define Team / group;
  define y / analysis sum;
  rbreak after / summarize;
run;

Re: proc report-Display values in millions instead of thousands

rudfaden — Wed, 08 Aug 2018 08:22:39 GMT

Try using a picture format

Data tbl;
input ID Team $ y;
cards;
1 a  1000
2 a  2000
3 a  3000
4 b  4000
5 b  5000
;
run;

proc format;
picture million (round fuzz=0)
0 -high = '9.999.999' (prefix='' mult=1000);
run;

proc report data=tbl nowd;
  column Team y ;
  define Team / group;
  define y / analysis sum;
  format y million.;
  rbreak after / summarize;
run;

Re: proc report-Display values in millions instead of thousands

Ronein — Wed, 08 Aug 2018 10:13:36 GMT

Thank you very much.

I want to get different results.

For "a" will get value 6 (because it is 6 millions)

For "b" will get value 9 (because it is 9 millions)

For total will get value 15(because it is 15 millions)

However :

In your outcome I see 6.000.000 for "a"

In your outcome I see 9.000.000 for "b"

In your outcome I see 5.000.000 for 'total' (which is error anyway)

Re: proc report-Display values in millions instead of thousands

PaigeMiller — Wed, 08 Aug 2018 10:44:46 GMT

@Ronein wrote:

I want to get different results.

For "a" will get value 6 (because it is 6 millions)

For "b" will get value 9 (because it is 9 millions)

For total will get value 15(because it is 15 millions)

However :

In your outcome I see 6.000.000 for "a"

In your outcome I see 9.000.000 for "b"

In your outcome I see 5.000.000 for 'total' (which is error anyway)

Certainly, you could make the very simple change to the Picture format yourself and solve the problem.

Re: proc report-Display values in millions instead of thousands

rudfaden — Wed, 08 Aug 2018 11:06:47 GMT

proc format;
picture million (round fuzz=0)
0 -high = '009.999.999' (prefix='' mult=1000);
run;

proc report data=tbl nowd;
column Team y ;
define Team / group;
define y / analysis sum;
format y million.;
rbreak after / summarize;
run;