topic Re: Source code to open SAS output with Microsoft WORD the same as HTML in ODS and Base Reporting

Source code to open SAS output with Microsoft WORD the same as HTML

MohamedYehia — Wed, 30 Aug 2017 13:06:49 GMT

Dear All,

I got an RTF SAS output file From someone I don't know (i.e. saved and opened as a word document) and when I right clicked the file and opened the "source Code", it was an HTML file not RTF one!!!. When I opened the file with GOOGLE CHROME it was opened with the same formatting as with the RTF. I mean the source code of the file is HTML and it can be opened with WORD and any browser.

For me I am saving my file using this ODS code to save the output " ods html file= "C:\Users\Administrator\Desktop\XXX.html

ods html close;" . This will open the file as HTML file. I want to open it with Microsoft word and gives me the same format as HTML like the file I received.

Is there a Syntax to use in the sourcde code that can open the file as HTML and WORD (Word format like HTML)?.

Thanks.

Yours,

M.Yehia

Re: Source code to open SAS output with Microsoft WORD the same as HTML

Ksharp — Wed, 30 Aug 2017 13:28:24 GMT

Try Change its suffix name.

"C:\Users\Administrator\Desktop\XXX.html

-->

"C:\Users\Administrator\Desktop\XXX.rtf

or use other ods destination like:

ods tagsets.msoffice2k ...........

ods tagsets.rtf................

ods tagsets.excelxp.........

Re: Source code to open SAS output with Microsoft WORD the same as HTML

MohamedYehia — Sun, 03 Sep 2017 18:08:03 GMT

I will post here the 2 codes and you will understand what I mean:

the file "1" is the right code that I received and can be saved and opened as both html or rtf:

[Edit: Long code removed and attached as files in this message from Vince]

Re: Source code to open SAS output with Microsoft WORD the same as HTML

MohamedYehia — Wed, 30 Aug 2017 14:23:44 GMT

the file "2" is my code that it is opened as HTML and if opened as RTF it will be of totally different formatting:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-type" content="text/html; charset=windows-1252">
<title>SAS Output</title>
</HEAD>
<BODY onload="startup()" onunload="shutdown()" vlink="#004488" link="#0066AA" leftmargin=8 rightmargin=8 bgcolor="#E0E0E0">
<SCRIPT LANGUAGE="JavaScript">
function startup(){ }
function shutdown(){ }
</SCRIPT>
<style type="text/css">

</style>
<script language="javascript" type="text/javascript">
<!--
function startup(){

}
function shutdown(){

}

//-->
</script>

//-->
</script>

Re: Source code to open SAS output with Microsoft WORD the same as HTML

Reeza — Wed, 30 Aug 2017 14:45:41 GMT

@Ksharp is correct, someone is probably playing around with the extension name for the file and not using the correct one. Word can open HTML files though, that's always been the case, so you can save your HTML as a Word doc and/or HTML. These are not identical but I think you get the idea.

ods html path='C:\_localdata\' body='sample.rtf' style=meadow;
proc print data=sashelp.class;
run;
ods html close;

ods html file='C:\_localdata\sample.html' style=meadow;
proc print data=sashelp.class;
run;
ods html close;

Re: Source code to open SAS output with Microsoft WORD the same as HTML

MohamedYehia — Wed, 30 Aug 2017 14:56:08 GMT

Hi Reeza,

Thx a lot for the reply.

However , I run each syntax separately and i fkound the same problem which is there are differences between the WORD and HTML (HTML file table has blue titles and separated lines, while the word file doesn't)

if you check the code 1 I sent; you will find that the WORD file tables are separated by lines).

pls check the 2 codes I sent.

Thx

Re: Source code to open SAS output with Microsoft WORD the same as HTML

Tom — Wed, 30 Aug 2017 15:08:59 GMT

@MohamedYehia wrote:

Hi Reeza,

Thx a lot for the reply.

However , I run each syntax separately and i fkound the same problem which is there are differences between the WORD and HTML (HTML file table has blue titles and separated lines, while the word file doesn't)

if you check the code 1 I sent; you will find that the WORD file tables are separated by lines).

pls check the 2 codes I sent.

Thx

I am confused about what your issue is. It sounds like you have used SAS to create an HTML file and have opened it with a browser and also with WORD. You are concerned that WORD makes the file look different than the browser does. That is normal behaviour. You could probably also see differences just using different browsers.

If you want the file to always look the same then you probably want to create a PDF file instead. That is what PDF was desgned for.

Re: Source code to open SAS output with Microsoft WORD the same as HTML

Reeza — Wed, 30 Aug 2017 15:03:13 GMT

There's a blob of text, but this is one example where you should probably attach a file, not a wall of text.

I'm not going to work with that.

I did mention it's not identical, but the approach is the same. Open the HTML file if you'd like and save it in Word and you'll have the identical file. Most likely that's what the person did, or some variation of the above that managed to work. Note that you can do these types of things in multiple directions, ie I showed ODS HTML, you could try the same with ODS RTF or a different tagset. They could also have used a custom tagset. There's too many ways it could have been done - why don't you ask the person who sent you the file?

Re: Source code to open SAS output with Microsoft WORD the same as HTML

MohamedYehia — Wed, 30 Aug 2017 15:12:52 GMT

1) if you try to open the html file and save it as word, it will also generate a totally different one.

2) I can't ask the one who did that because he is an outsource personnel who is earning money in return of that work, so simply he will not give me the "no how" of his work 😄 😄

3) this is my email: "Mohamed_phr@hotmail.com" if you decided to run the both source codes and I know that the source code is too large, but btw its too simple, you will just copy paste each code and then right click the file and select open with "either chrome or word"

sorry for bothering u 😉

Re: Source code to open SAS output with Microsoft WORD the same as HTML

Reeza — Wed, 30 Aug 2017 15:21:12 GMT

If he's a contractor, the code he's written may be your company's IP so you should have access to it if you ask.

Re: Source code to open SAS output with Microsoft WORD the same as HTML

Cynthia_sas — Wed, 30 Aug 2017 16:33:49 GMT

I wonder if this new posting is related to this thread from a few weeks ago: https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-import-ods-html-to-rtf-output/m-p/387428#M19037

The bottom line is that if you use ODS HTML, you are making an HTML file, no matter what file extension you give the file. And if you "resave" the HTML file from inside WORD as a .doc or .docx, then you are asking WORD to convert from HTML to internal WORD format. Ever since Office 97, you have been able to open an HTML file with WORD and EXCEL, so that is something Microsoft implemented a long time ago.

The output from ODS HTML will not be the same as the output from ODS RTF.

Since I'm still not clear on what the issue is or why an HTML file is being created and then opened with WORD, I'm not sure that a "fix" is needed.

cynthia

Re: Source code to open SAS output with Microsoft WORD the same as HTML

ballardw — Wed, 30 Aug 2017 17:44:43 GMT

@MohamedYehia wrote:

Hi Reeza,

Thx a lot for the reply.

However , I run each syntax separately and i fkound the same problem which is there are differences between the WORD and HTML (HTML file table has blue titles and separated lines, while the word file doesn't)

The output of ODS HTML and ODS RTF will vary in colors, line types, fonts and almost every appearance issue because the ODS destinations have different default styles if you did not include the style on the ODS statement as @Reezadid.

Please show the code you actually ran.

@MohamedYehia wrote:

if you check the code 1 I sent; you will find that the WORD file tables are separated by lines).

pls check the 2 codes I sent.

I couldn't tell where your "code 1" may have ended and your "code 2" began and I'm not going to spend much time looking through several hundred lines of HTML code to compare things.

If you do not have the source code used to generate the tables do not expect us to reverse engineer any of the options that may have been used in Proc report which could have used different Break Rbreak or other options in other procedures that generated different styles of lines. If thas is what your are attempting then have the person send you the code that generated the output. But if they used a custom style or procedure template that may not contain all of the information.

And repeat, NONE of that output was Word it was all html.

Re: Source code to open SAS output with Microsoft WORD the same as HTML

Vince_SAS — Sat, 02 Sep 2017 00:07:07 GMT

I took your two blobs of HTML, saved them to files, and then attached them as output1.txt and output2.txt. As someone mentioned earlier, this is the preferred way to share a large amount of data.

The forum software wouldn't let me attach .htm files (!!) so download the files and rename them to output1.htm and output2.htm.

The output1.htm file was created using the HTML3 destination and the "Default" style supplied by SAS.

The output2.htm file was created using the HTML4 destination and a style that is similar to "Default". I see some differences but I'm unable to tell if they are due to being created by different versions of SAS, or if someone modified the "Default" style and used it here.

Open both files using a Web browser and you will see that they have a similar, but different appearance.

Now open both files using Microsoft Word. The two files look very different when rendered by Microsoft Word. The output1.htm file looks close to what you see in the Web browser. The HTML for the output2.htm file uses CSS to control the appearance, and apparently Microsoft Word does not handle the CSS very well.

Here is some sample code that illustrates how the files might have been created:

ods html3 file='C:\temp\vince_output1.htm' style=Default;
  proc means data=sashelp.class n mean median min max range; 
    class sex;
    var age height weight;
  run; quit;
ods html3 close;


ods html4 file='C:\temp\vince_output2.htm' style=Default;
  proc means data=sashelp.class n mean median min max range; 
    class sex;
    var age height weight;
  run; quit;
ods html4 close;

Vince DelGobbo

SAS R&D

Re: Source code to open SAS output with Microsoft WORD the same as HTML

MohamedYehia — Sat, 02 Sep 2017 11:44:08 GMT

Hi Vince_SAS,

you can't imagine how happy I am 😄 ..... you are really my hero 😉

HTML3 is the solution .

I really appreciate your kind assistance

thx again and good luck

Yours,

M.Yehia