topic Re: Display 1 million as 1 in SAS Programming

Display 1 million as 1

Ronein — Thu, 05 Nov 2020 07:14:25 GMT

Hello

I am using proc report to calculate sum of revenue and the numbers are in local currency (PLN).

I need to display the numbers in millions:

for example:

1,000,000 will be displayed as 2

161,391,185 will be displayed as 161.3(then I want to round it to 161)

35,257,624,389 will dispalyed as 35,257.6 (then I want to round it to 35,258)

what is the correct way to do it with picture format?

Data example;

input x;

cards;

1000000

161391185

35257624389

;

run;

Re: Display 1 million as 1

ChrisNZ — Thu, 05 Nov 2020 07:17:26 GMT

What have you tried? Did you see the multiplier option?

Re: Display 1 million as 1

yabwon — Thu, 05 Nov 2020 08:15:05 GMT

As @ChrisNZ said, use the ROUND option:

proc format;

picture zlotowkiR (ROUND)
low - high = '000,000,000 mln PLN' (mult=0.000001)
;

picture zlotowki
low - high = '000,000,000.0 mln PLN' (mult=0.00001)
;
run;


Data example;
format x best. y zlotowki. z zlotowkiR. ;
input x;
y = x;
z = x;
cards;
1000000
161391185
35257624389
;
run;
proc print;
run;

pozdrowienia

Bart

Re: Display 1 million as 1

ballardw — Thu, 05 Nov 2020 15:40:35 GMT

@Ronein wrote:

Hello

I am using proc report to calculate sum of revenue and the numbers are in local currency (PLN).

I need to display the numbers in millions:

for example:

1,000,000 will be displayed as 2

161,391,185 will be displayed as 161.3(then I want to round it to 161)

35,257,624,389 will dispalyed as 35,257.6 (then I want to round it to 35,258)

what is the correct way to do it with picture format?

Data example;

input x;

cards;

1000000

161391185

35257624389

;

run;

Which is it? The subject line of your post says "Re: Display 1 million as 1". Your data above says "1,000,000 will be displayed as 2".

Do you have any values less than 1,000,000? If so you need to specify how you expect those to appear as well as a number of possible solutions that work for your shown values may well result in those other values not appearing as desired.