Hi All,
Dollar value original
$24,995,882.24 |
$3,795,926.11 |
$2,960,272.50 |
$2,340,307.13 |
Dollar value in 000 format
$24,995 |
$3,795 |
$2,960 |
$2,340 |
I create the report using ods tagsets.excelxp and proc report
Is it possible to show in 000 format but when I click on the cell i can see the full value ?
Currently the report produces the value in 000 format but as in excel I wanto print it in 000 format but when the user clicks on cell he needs to be able to view the full decimal value
How are you applying the format?
A tagattr format should work, assuming there's an Excel format that allows for the format you want.
I am applying the format using Tagattr
proc format library=delfmt.Delq;
picture dollrfmt
low - < 0 = '0000,009)' (mult=.001 prefix='($')
0 = '-'
0 < - high = '000,009' (mult=.001 prefix='$');
run;
define Dolrs / order order=data " $ Dollars * (000)" format=dollrfmt. style={tagattr='format:$###,###'};
what I am trying to achieve progrmatically is
$ Dollars (000) |
$24,995 |
$3,795 |
$2,960 |
$2,340 |
When i click on the above display it should display the below value in cell
24995.88224
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.