topic Proc Report - Data Format in ODS and Base Reporting

Proc Report - Data Format

newbi — Thu, 11 Aug 2011 19:45:19 GMT

Good Afternoon,

I have data value ‘Ace & 8s’ and proc report is displaying ‘Aces & 8®s’

How can i show the actual data value in report ?

Thanks

Ksharp — Thu, 18 Aug 2011 08:41:17 GMT

It looks like your origin data value contains some unicode .

You need to use compress() to keep the character you want.

Ksharp

newbi — Thu, 18 Aug 2011 17:16:32 GMT

I used the following code

test=notpring(Name);

if test>0 then Name=substr(Name,1,test-1) || substr(Name,test+1)

The value return for name was - ACES &8S

How can i get the value to shown as : ACES & 8s ?

Thanks

newbi — Thu, 18 Aug 2011 17:34:24 GMT

I figure it out. My DI job takes care of that part. Thanks for all your help.