Date: Mon, 16 Apr 2001 14:29:59 -0600
Reply-To: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject: Re: Loading a SAS Dataset to MS Excel w/ formatted cells?
Content-Type: text/plain; charset=us-ascii
That's an interesting idea, but it has an important restriction - that you be running SAS under Windows. If you want to create your document on a different platform - and I'd guess that most SAS CPU cycles are not executed under Windows - you'd have to use the SYLK or HTML approach.
If I knew that all users would have Excel 2000, I'd probably use the HTML approach, but give the resulting file a .XLS extension.
--
JackHamilton@FirstHealth.com
Development Manager, Technical Group
METRICS Department, First Health
West Sacramento, California USA
>>> "Howard Schreier" <Howard_Schreier@ITA.DOC.GOV> 04/16/2001 1:12 PM >>>
There is a highly relevant "plastic" coming up at SUGI:
---
Using Dynamic Data Exchange to Export Your SAS Data to MS Excel -- Against
All ODS, Part I
Koen Vyverman, Fidelity Investments - Luxembourg
Paper 11
The manifold features of the Output Delivery System (ODS) certainly make
life easier when creating output in a whole slew of contemporary file
formats like HTML, PDF, XML, ... However, when working with business users
the question one usually hears is: Can I have that as an Excel file? Sure,
the SAS System provides ways to export your data to Excel, but most likely
it won't do this exactly the way you'd like to have it! Dynamic Data
Exchange (DDE) allows fully customized Excel output. This paper will show
step by step not only how to get your SAS data into an Excel workbook, but
also how to specify exactly where you want it, and with what formatting
applied. As a bonus, a macro is provided, harnessing the power of DDE in an
easy-to-use manner and allowing you to create really fancy Excel documents
from within any SAS program.
Tuesday Morning
Regency A-C, Hyatt
10:00 AM
---
Unfortunately, if inevitably, several other eminent SAS-L folks are
presenting at the same time. See
http://www.sas.com/usergroups/sugi/sugi26/grid.tueam.html
On Mon, 16 Apr 2001 12:13:57 -0400, Brittain, James <zqr0@CDC.GOV> wrote:
>Is there a way to load data into a MS Excel spreadsheet and have control
>over the cell formatting, not the data formats, like BOLD, SHADING, and
>GRIDLINES?
>
>I was have been loading data into Excel by either creating a .CSV file and
>opening it with Excel or directly creating .XLS using SAS/ACCESS DBLOAD
>procedure. The problem is that once I have the data in the spreadsheet I
>have to go in and format the cells the way I want them to look. Usually I
>add gridlines, make the labels bold, shade some cells, modify the width of
>columns, and change cells to "wrap text". There are times that I have to
>create multiple spreadsheets that need to look the same but have different
>data.
>
>I was thinking that I could create an Excel template and call it with
DBLOAD
>or create an empty spreadsheet the way I want it and APPEND to it but from
>what I understand APPEND is not available with the XLS DBMS in SAS/ACCESS.
>I would think that something along this line would be the idea because I do
>not see and SAS syntax for the DBLOAD procedure that allows for formatting
>the cells like (row_1 = BOLD, row_2 = NOBOLD).
>
>Another thing that I noticed is when I use the DBLOAD procedure with long
>character variables it is truncating them to $200. Is this because the
>DBLOAD (.XLS) procedure has not been updated to the long character
variables
>yet?
>
>Thanks in advance for any and all help,
>
> Jim Brittain
| 
