06-28-2017 12:21 PM
Hi SAS Experts,
Is there is anyway to get the million format on dollar values. Below is the data and code.
informat amnt dollar14.;
format amnt dollar14.;
input amnt person$;
Note: Amnt should be numeric value only.
Thanks & regards,
06-28-2017 12:58 PM
I created my own picture format for this purpose, you probably want to modify the code below for your exact needs
proc format; picture million low-high='0,000,009.9MM' (prefix='$' mult=.00001); run;
06-29-2017 07:28 AM
Instead of using the same picture for all values low to high, you specify a picture with a minus sign for negative values, and a different picture for positive values, with no minus sign.
06-29-2017 08:41 AM
Ya I tried something like this, but the negative values are resuled in millions(like 1000000) and positive values are resulted in (like 1.0).
picture million -1 - -45000000='0,000,009.9M' (mult= -.00001)
1 - high='0,000,009.9M' (mult=.00001);
Need further help from the community? Please ask a new question.