topic Re: How to convert SAS output to XML file in ODS and Base Reporting

How to convert SAS output to XML file

amypandit — Tue, 10 Apr 2018 14:44:16 GMT

I have sas output, but no data, Is it possible to convert the SAS output to XML?

Re: How to convert SAS output to XML file

Reeza — Tue, 10 Apr 2018 14:54:01 GMT

What are you calling 'SAS output' and what do you mean by XML? Are you referring to the tagset version or a file that you want to open with Excel?

Re: How to convert SAS output to XML file

amypandit — Tue, 10 Apr 2018 14:57:44 GMT

I would like to convert SAS output (.lst) to XML? any method is fine with me, Is there a way?

Re: How to convert SAS output to XML file

Reeza — Tue, 10 Apr 2018 15:07:10 GMT

Not one that would have any decent structure. What is the end goal here? XML are structured output, LST files are designed for viewing/reporting. ODS TAGSETS.EXCELXP generates a type of XML file but it looks like an Excel file. You can try that I suppose, and see if it meets your needs.

ods tagsets.excelxp file='demo.xml' style=meadow;

proc print data=sashelp.cars(obs=10);
run;

proc print data=sashelp.class(obs=5);
run;

ods tagsets.excelxp close;

And then if you want a data set to an XML file you can use ODS XML.

 libname newfile xml 'c:\_localdata\temp.xml'
           xmltype=export;
   data newfile.test;
      set sashelp.class;
   run;

   libname newfile;