topic Re: Regarding ODS tagsets in ODS and Base Reporting

Regarding ODS tagsets

JasonNC — Thu, 08 Dec 2016 23:17:49 GMT

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

Re: Regarding ODS tagsets

Reeza — Thu, 08 Dec 2016 23:31:42 GMT

How are you applying the format?

A tagattr format should work, assuming there's an Excel format that allows for the format you want.

Re: Regarding ODS tagsets

JasonNC — Fri, 09 Dec 2016 17:12:47 GMT

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