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

[deleted_user]

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

[AngelaHall]

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