The SAS Output Delivery System and reporting techniques

Proc report problem

Reply
Occasional Contributor
Posts: 9

Proc report problem

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?

Super Contributor
Posts: 394

Re: Proc report problem

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 '%'?

Occasional Contributor
Posts: 9

Re: Proc report problem

Thank you!!!!!

It works Smiley Happy

Ask a Question
Discussion stats
  • 2 replies
  • 279 views
  • 3 likes
  • 2 in conversation