topic Re: Can we change .lst file into word document file? in SAS Programming

Can we change .lst file into word document file?

ArchanaSudhir — Thu, 01 Sep 2016 15:51:40 GMT

HI,

Can we change .lst file into word document file? so that it is easier to share?

Thanks,

Archana

Re: Can we change .lst file into word document file?

DocSteve — Thu, 01 Sep 2016 16:00:25 GMT

One way, I'm sure not the only way, is use ODS and set the output destination to html and from there you can read the file into MS-Word, MS-Excel, and a lot of other things. It's two steps, but I do not seem to recall ever seeing .docx as an ODS destination.

Re: Can we change .lst file into word document file?

ballardw — Thu, 01 Sep 2016 16:05:16 GMT

ods rtf file="C:\path\documentname.rtf";

/* any procedures that generate list output*/

ods rtf close;

Will send all of the procedures withing the ODS "sandwich" (ods rtf/ ods rtf close statements) to the specified file. Word reads RTF files.

Note that you have options to change the ODS style which controls font, fontsize, color and other appearance option as well as behviors for titles (in Word header or body of document) and others.

Re: Can we change .lst file into word document file?

Reeza — Thu, 01 Sep 2016 16:06:54 GMT

I would recommend switching to ODS RTF instead, by embedding your code between ODS RTF statements.

RTF files can be opened by Word.

ods rtf file='sample.rtf' style=meadow bodytitle;

title 'this is my sample output';
proc means data=sashelp.class;
run;

title 'this is a different table';
proc freq data=sashelp.cars;
table make*model/list;
run;

ods rtf close;