topic Query on report generation in SAS Programming

Query on report generation

AntuMaria — Wed, 15 Jul 2020 06:35:27 GMT

Hi all,I am facing an issue in the generation of docx output.I am attaching the outputs that is obtained in both the rtf and docx output.In docx output the style is also getting printed with the output and the border lines also appear. My requirement is the same output in rtf to get in docx. Could please suggest the method in docx to get the similar output as in rtf.

Re: Query on report generation

ballardw — Wed, 15 Jul 2020 14:57:00 GMT

With code how can we make a suggestion of what might be needed?

I suspect the issue will revolve around setting the desired ODS STYLE on the ODS destination statement. But you will need to show the destination statements used for BOTH of those outputs.

Re: Query on report generation

AntuMaria — Fri, 17 Jul 2020 08:29:52 GMT

Hi,i have attached the sas code,dataset used and the obtained rtf output.How could i get a similar report in docx using ODS WORD?

Re: Query on report generation

ghosh — Fri, 17 Jul 2020 16:27:19 GMT

This reference paper has helped me in using ODS WORD (you do need SAS release 9.4m6)

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/3235-2019.pdf

Re: Query on report generation

Cynthia_sas — Fri, 17 Jul 2020 22:52:00 GMT

Hi:
While ODS WORD may help you -- you're going to have some issues. First of all, your STYLE template uses the REPLACE statement, which was deprecated and made obsolete in SAS 9.2 with the introduction of the CLASS statement.
Next, the PROC REPORT code is full of RTF control strings. Those will not work with ODS WORD, so you'll have to change those.
What version of SAS are you running?
Cynthia

Re: Query on report generation

AntuMaria — Mon, 20 Jul 2020 02:21:52 GMT

thank you..let me try with this one .

Re: Query on report generation

AntuMaria — Mon, 20 Jul 2020 02:24:03 GMT

I am using SAS 9.4 . I had checked with some docx control strings. But nothing worked in ODS WORD.

Re: Query on report generation

Cynthia_sas — Mon, 20 Jul 2020 16:50:41 GMT

Hi:
RTF stands for "Rich Text Format" -- it is a specification for how to describe an ASCII text document which contains RTF control strings that can be opened with many different word processors. As I remember, RTF was originally the format used to exchange documents between the PC and the Mac and other computers with different word processors. However, the docx format, is a Microsoft Open Office XML format for Word documents.
Although Microsoft Word can open a ASCII .RTF file, and Word can open a .DOCX file -- I would not expect a .docx file to contain RTF control strings. A .DOCX file is designed according to the Microsoft specification, which is different than the RTF specification.
If you want to create an RTF file and RTF gives you the style that you want. Just open the RTF file in Word and re-save it as a .DOCX file if you want to create a .DOCX file using ODS WORD, then you'll need to change your code to get rid of the RTF control strings and replace them with other controls. You may want to open a track with Tech Support on how to generate what you want with ODS WORD. But using RTF control strings inside ODS WORD will probably NOT work.

Cynthia