10-06-2016 04:16 PM
Hi I am getting below format issue
picture dollrfmt (round)
low - < 0 = '00,000)' (mult=.001 prefix='($')
0 - high = '00,000' (mult=.001 prefix='$');
The number are represented below in 000 format as i want to represent the amounts in 000 's format but i am getting decimals which i don't want
I am expecting the results in below format
I am using ods excelp xp tagsets and proc report,I am applying the format in proc report.
10-06-2016 04:28 PM
Excel doesn't always honor the SAS format unless you use TAGATTR to specify the override appearance once it gets to Excel in the proc report code.
I suspect that if you look at the cell in Excel for the number format you may actualy see it is set to a dollar format which will default to 2 decimals in Excel.
10-07-2016 05:51 PM
I think the first line below should probably do the trick in terms of a TAGATTR. The second line below is an example from a PROC REPORT. Different format, but it should give you an idea of what it would look like in a PROC REPORT.
[TAGATTR="FORMAT:$#,##0"] DEFINE TIP_PIN_N / DISPLAY STYLE(COLUMN) = [BACKGROUND=WhiteSmoke TAGATTR="FORMAT:##########" FONT=("Calibri",8pt) ];