topic Re: DOCX Support in SAS in ODS and Base Reporting

DOCX Support in SAS

suhas_sanjee — Tue, 04 Oct 2016 12:55:51 GMT

We have a requirement to generate a report in DOCX format using UNIX SAS. I cant think of doing this without using DDE and DDE doesn't work in UNIX. Do you have any suggestions? Any help would be really appreciated.

Thanks

Suhas

Re: DOCX Support in SAS

Reeza — Tue, 04 Oct 2016 13:08:59 GMT

RTF file + a VBScript or Unix to save as doc after.

Re: DOCX Support in SAS

RW9 — Tue, 04 Oct 2016 13:28:45 GMT

Format is not so relevant, most would just export to RTF as @Reeza has given you. RTF can be read by Word just the same.

Re: DOCX Support in SAS

suhas_sanjee — Tue, 04 Oct 2016 17:33:44 GMT

We are currently producing the output in RTF. However, there is a tool that consumes the output and it can only handle DOCX files. Saving manually is not ideal as you would lose the audit trail. VBScript is a good suggestion but as far as I know it doesn't work on UNIX. Any thoughts?

Re: DOCX Support in SAS

Reeza — Tue, 04 Oct 2016 18:11:45 GMT

There's probably a Python or command line utility that can be used on Unix. I've used Python before to do the conversion.

Re: DOCX Support in SAS

suhas_sanjee — Tue, 04 Oct 2016 19:15:35 GMT

Interesting, do you have an example Python command or related documentation that I can refer to get more information on converting RTF files to DOCX in Unix?

Re: DOCX Support in SAS

Reeza — Tue, 04 Oct 2016 19:52:37 GMT

No, it was developed as part of a consulting contract.

For this type of question, it's not really a SAS issue. I would try posting to StackOverflow, though they require that you have made an attempt to solve the problem. Perhaps searching on there will yield results from someone else.

Good Luck.

Re: DOCX Support in SAS

suhas_sanjee — Wed, 05 Oct 2016 13:56:08 GMT

Thanks for your time. I was hoping to get some documentation so that I could make an attempt. I will check StackOverFlow as you suggested.

Re: DOCX Support in SAS

rogerjdeangelis — Sat, 08 Oct 2016 01:16:28 GMT

check out

https://listserv.uga.edu/cgi-bin/wa?A2=SAS-L;124ae07.1610a

You should be able to do this with the IML interface to R

There are many R/Python packages create, update or even convert rtf to DOCX