Date: Sun, 11 Jul 2010 12:53:04 -0700
Reply-To: Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject: Re: REvised: How to send a PROC REPORT using SAS EMAIL
In-Reply-To: <02b601cb212d$aa45fef0$fed1fcd0$@com>
Content-Type: text/plain; charset=us-ascii
Please post your code (to SAS-L, not me).
--
Jack Hamilton
jfh@alumni.stanford.org
Caelum non animum mutant qui trans mare currunt.
On Jul 11, 2010, at 12:17 , Lizette Koehler wrote:
> I know how to send email when it is attached as a file. But how do I imbed
> a SAS PROC REPORT output in the email?
>
>
>
> I have tried creating the PROC REPORT with OUT=emailit but the results
> would need to be reformatted.
>
>
>
> Is there an easy way to get the results from the PROC REPORT into the body
> of the email?
>
> Or do I just need to take the date from the OUT= in the PROC REPORT step and
> then use PUT statements with HTML?
>
>
>
> This is running on a mainframe running z/OS V1.9 and SAS 9.1.3. I have been
> working with ODS but it is not doing what I want.
>
>
>
> The proc report will display as:
>
>
>
> REPORT FOR CA PRODUCT USAGE
>
>
>
> CA
>
> SYSTEM PRODUCT
>
> DATE HOUR NAME CODE PRODUCT NAME
>
> -----------------------------------------------------------------
>
>
>
> 07JUL10 0 LPAR1 RS CA-RC/SECURE
>
> 08JUL10 0 LPAR1 RA CA-RECOVERY_ANALYZER
>
> RS CA-RC/SECURE
>
> RW CA-REPORT_FACILITY_FOR_TSO
>
> 09JUL10 0 LPAR1 RA CA-RECOVERY_ANALYZER
>
> RW CA-REPORT_FACILITY_FOR_TSO
>
>
>
>
>
> However, with OUT=newdsn they are just one liners and I would need to
> reformat it to look like the above. If I use ODS with HTML, XML, RTF, or
> LISTING it just does not display at all.
>
>
>
> I have done this process with PC quite successfully. However, doing this on
> the Mainframe is proving more challenging. I have been reading the SUGI
> papers and others, but cannot seem to work the magic.
>
>
>
> Any help is appreciated.
>
>
>
>
>
> Lizette
| 
