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?
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 '%'?
Thank you!!!!!
It works
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.