Date: Fri, 9 May 2003 12:28:40 -0400
Reply-To: "Delaney, Kevin P." <khd8@CDC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Delaney, Kevin P." <khd8@CDC.GOV>
Subject: Re: future of data _null_ in SAS 9.1
For those of you with SAS 9.0 (:-), ODS LAYOUT is experimental but seems to
work pretty well, haven't tried the DATA _NULL_ stuff so I can't speak to
If you really need this stuff in the RTF destination you could output it as
HTML with a .doc extension, open it in Word, modify it and save it as a real
RTF or Doc file, I guess...
ods html file="C:\temp\test export to Word.doc" style=minimal;
proc print data=sashelp.class;
ods html close;
options noxwait noxsync;*Don't want to wait for word to finish, and we want
it to run in the background;
*This checks to see if word is open (necessary for DDE System (Wordbasic)
commands to work,
and if not, opens it;
length fid rc start stop time 8;
if (fid le 0) then do;
do while (fid le 0);
if (time ge stop) then fid=1;
*Sets up the DDE call to word;
filename wordsys dde "winword|system";
put '[Fileopen "C:\temp\test export to Word.doc"]';*Opens your file, maybe
you have it open in word already?
but why would you use SAS if you did?;
*put other Wordbasic commands to change formatting, or run a VBA Macro etc.;
put '[FileSaveAs .Name = "' "C:\temp\test.rtf" '"
.format=ConverterLookup("Rich Text Format")]';
*could be .format=6 (which is what is returned by Converterlookup
*Could also be .format=0 or converterlookup("Normal") for a Worddoc;
From: Carey Smoak [mailto:carey.smoak@ROCHE.COM]
Sent: Friday, May 09, 2003 11:50 AM
Subject: future of data _null_ in SAS 9.1
I wanted to expand a little bit on a part of my post on "PharmaSUG - Miami
Beach" in regards to these two papers - "ODS Layout: Arranging ODS Output as
You See Fit" by Brian Schellenberger and "Next Generation Data _NULL_:
Report Writing Using ODS OO Features" by Dan O'Connor.
As I mentioned in my previous post, ODS Layout and ODS OO will be available
as experimental features in SAS 9.1 (available in Q1 of next year). What I
forgot to mention is that initially ODS Layout and ODS OO will only work
with the HTML, Printer and PDF destinations, i.e., it will not work with the
I had an extensive discussion with Dan O'Connor in the demo room about why
ODS Layout and ODS OO will not work with RTF. According to Dan, SAS's new
technology (the new ODS Layout and the ODS OO) are using new technologies
that are beyound the current capabilities of RTF. According to Dan,
Miscrosoft's code for using RTF with Microsoft Word is antiquated and needs
to be updated. Once Microsoft does this update then SAS will be able to
include RTF in ODS Layout and ODS OO. Dan did mention that he was hopeful
that Microsoft might be able to get this task done by the time ODS Layout
and ODS OO become production in SAS 9.2 (release date unknown).
Here is a portion of my post ("PharmaSUG Miami Beach" on this issue (for
those of you who did not read my previous post):
ODS Layout and ODS OO are designed to work together to help produce better
reports. ODS Layout has two formats: absolute and gridded. Basically these
formats allow the user to define the page "layout."
ODS OO ("OO" stands for object oriented) gives the programmer new "data
_null_" tools. OO is very different than current data _null_ commands, so
it will take some adjusting by SAS programmers. However, based on the
results that I saw at PharmaSUG, I would say that it will be well worth
learning how to use ODS OO.
Dan O'Connor also mentioned that "statistical graphs" (e.g., survival
analysis, regression, time series, etc) will also be able to be produced
with ODS OO in SAS 9.1. I saw a demo of the "statistical graphs" in the
demo room and it was pretty impressive.
Carey G. Smoak
Senior Clinical Programmer Analyst
Roche Molecular Systems, Inc.
4300 Hacienda Drive
Pleasanton, CA 94588