Proc report problem

pihu_11 — Tue, 14 May 2013 03:28:06 GMT

Hi All,

I have a SAS data set in which I have variable var1 which has some of its values as 10^9/L.

I am using proc report and ODS to create an xml output. In the output, I am getting values for var1 as 10/L instead of 10^9/L.

I am also using ods escapechar = '^';. This also doesn't work. The part of the code is:

ods escapechar="^";

ods _all_ close;

ods tagsets.ExcelXP

options(frozen_headers='2'

sheet_name="data1"

absolute_column_width='10,10,10');

proc report data=final nowindows split='*';

column var1 var2 var3;

define var1/ display 'Variable One' ;

define var2/ display 'Two' ;

define var3/ display 'Three';

quit;

What can be the reason for not proper display of values?

Re: Proc report problem

Tim_SAS — Tue, 14 May 2013 12:29:01 GMT

But '^' is working, that's why you're getting 10/L instead of 10^9/L. Choose an escape char that doesn't appear in your data. Maybe '~' or '%'?

pihu_11 — Tue, 14 May 2013 13:59:13 GMT

Thank you!!!!!

It works