Traditional web-based reporting with SAS BI tools

WRS displays mixed results using the DOLLAR6.0 format in InfoMap

Reply
N/A
Posts: 0

WRS displays mixed results using the DOLLAR6.0 format in InfoMap

My WRS report displays numeric data as mixed - some have $, commas, 1.05E16, etc. I've tried various formats in the InfoMap, with no luck.

Any ideas?

Thanks
SAS Employee
Posts: 238

Re: WRS displays mixed results using the DOLLAR6.0 format in InfoMap

It sounds like the length isn't long enough.

For instance - if the amount is $100,000,000 with dollar6.0 would show 1E8.
Likewise, if the amount is $100,000 it would show 100000.
If it was $10,000 it would show $10000
and if it was $1000 it would be $1,000.

The , and the $ are included in the length of the variable.
If your largest variable is 17 numbers 'long', I would suggest attempting a dollar23.0.

Hope this helps.
~ Angela
http://sas-bi.blogspot.com
Ask a Question
Discussion stats
  • 1 reply
  • 218 views
  • 0 likes
  • 2 in conversation