Date: Tue, 2 Jul 2002 13:49:02 -0400
Reply-To: "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Dorfman, Paul" <Paul.Dorfman@BCBSFL.COM>
Subject: Re: ods rft/pdf and mvs
Content-Type: text/plain; charset=iso-8859-1
> From: Pete Lund [mailto:pete.lund@NWCSR.COM]
>
> Hi all-
> I have a question for a colleague. He doesn't have access
> to SAS-L and I don't have access to a mainframe.
>
> He wants to create a PDF and/or RTF files with ODS on a mainframe to be
downloaded
> and used on a PC. They're running V8 on OS/390.
Pete,
Greetings and salutations. I have not created a PDF yet (should try soon),
but have been playing with RTF for whole 2 days (that is how long we have
had 8.2 under the local z/OS). To me, a nice RTF feature compared to HTML is
that it provides for correct pagination in Word regardless of font size and
such, and if the latter de(in)creased manually afterwards, Word repaginates
the report correctly, so it can be printed in an orderly fashion.
The big questions are:
>
> - How to allocate the output files on the mainframe
Allocate them as RECFM=VB. Choose a very long record length, say
LRECL=20004. This will make sure that even the longest RTF (of HTML if
needed) script line will fit on a single line. Let the system assign the
block size by letting BLKSIZE=0 (for 3390 DASD it will result in 27998).
Usually, I allocate this kind of file as a PDS, so that different reports
can be written to different members.
On the ODS statement, it is imperative to include the option RS=NONE. The
file reference in BODY= (or FILE=) can be both a DD name (of SAS fileref) or
full physical. However, you cannot create a DD or fileref reference to a PDS
and then code FILE=PDSREF(member). Example:
ods rtf file="XXX.YYY.ZZZ(REPORT1)" rs=none ;
.............
ods rtf close ;
> - How to move them down to the PC (just binary ftp?)
I send all such files as an e-mail attachment. This allows to send more than
one file at once, ro the same file with different extensions, and to more
than one recipient. Example:
FileName Send Email
Subject = "Summary Report ZZZZ"
From = "Abracadabra Support"
To = (
'Joe.Smith@xxxxx.com'
'John.Doe@yyyyy.com'
)
Cc = (
'Peggy.Cooper@zzzzz.com'
'Tyler.Taylor@wwwww.com'
)
Attach = (
"XXX.YYY.ZZZ(REPORT1)" Ext='rtf'
"XXX.YYY.ZZZ(REPORT2)" Ext='html'
"XXX.YYY.ZZZ(REPORT3)" Ext='xls'
)
;
Data _Null_ ;
File Send ;
Run ;
> - Do they just get renamed on the PC with a .pdf or .rtf/.doc
> extension?
With the method above, they will appear in the attachments as specified in
ext=. Note that for this method to work, your colleague will have to know
the correct value for the EMAILHOST= option. Usually it is generic accross
the enterprise and someone should know it. Else as a short-term solutions,
before the generic SMTP address is obtained, it is possible to send this
from DOS:
ping smtp
hit enter and steal the address, but it is subject to change. Finally, in
anticipation of many programs sending reports or files via e-mail
attachments, it is a good idea to use a user config file with the generic
EMAILHOST= and point all such programs to this config rather change the
option than at all invocations if need be.
HTH.
Kind regards,
====================
Paul M. Dorfman
Jacksonville, Fl
====================
>
> Any help would be appreciated.
>
> Thanks-
> Pete
>
Blue Cross Blue Shield of Florida, Inc., and its subsidiary and
affiliate companies are not responsible for errors or omissions in this e-mail message. Any personal comments made in this e-mail do not reflect the views of Blue Cross Blue Shield of Florida, Inc.
