The SAS Output Delivery System and reporting techniques

Regarding ODS tagsets

Reply
Regular Contributor
Posts: 155

Regarding ODS tagsets

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

 

Super User
Posts: 17,963

Re: Regarding ODS tagsets

How are you applying the format? 

 

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

Regular Contributor
Posts: 155

Re: Regarding ODS tagsets

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

Ask a Question
Discussion stats
  • 2 replies
  • 163 views
  • 0 likes
  • 2 in conversation