Date: Mon, 9 Dec 2002 10:34:39 +0100
Reply-To: WIELKI Andre <wielki@INED.FR>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: WIELKI Andre <wielki@INED.FR>
Subject: Re: Mainframe SAS, FTP, and Excel
In-Reply-To: <b0ebec23.0212071220.5087d54@posting.google.com>
Content-Type: text/plain; charset="us-ascii"; format=flowed
At 12:20 07/12/2002 -0800, Biff Canlett wrote:
>I did a project on contract this summer where we developed ISPF panels
>which used user input to tailor SAS reporting programs which were then
>emailed to the requester. The process worked out very well, and I
>think the email option is much better than FTP for most uses since no
>additional steps are required at the receiving end. Other posters
>have given you the details on how to make this work, but I would like
>to suggest that you consider the format of your reports.
>
>For my project I needed to change my attitude about how a report
>should look. Worksheets shouldn't have titles and column headings
>every 40-60 lines, and in most cases shouldn't have subtotals.
>Footers will be overlooked, and while supressing repeating column
>values may look good in print, it fouls up the valuable filtering
>available in Excel. SAS titles captured by ODS and read into excel
>have tendency to be crammed into the first column even though a
>browser will display them properly. Here are some tricks to avoid
>some of these issues.
Tricks there are a lot!
Biff,
Do you know there is a a text you may read to discover a lot of ods
solutions working
for producing a file working with Excel .
I have tested all of them and except two or three(I am under Office XP
that's the reason)
they are working.
(see of sas institute at
at
http://www.sas.com/rnd/base/topics/templateFAQ/Excel1.pdf
"Using ODS To generate Excel Files" by Chevell Parker
>Before your ODS call, set the PS option to a large value {32000} to
>supress subsequent titles and column headings.
>
>Avoid use of SAS titles. I used PROC REPORT instead of PROC PRINT.
>Use "COMPUTE BEFORE _PAGE_ / STYLE={JUST=L}; " or something similar,
>with a LINE statement instead of the TITLE statement.
>
>Do not use split characters in your labels. They can cause Excel to
>split the lable into two cells, which can cause problems with the
>filter line.
>
>Avoid using more than one group or order variable to avoid the
>supression of repeating values, which would mess up filtering. There
>is a way to overcome this suppression by using calculated and data
>step variables inside the proc report.
>
>Avoid subtotals. An Excel user might inadvertently include them in a
>column total.
>
>HTH
___________
WIELKI Andre
INED - Service Informatique
133 Bd Davout,
75 980 Paris Cedex 20
FRANCE
Tel: 01 56 06 21 54
| 
