Date: Fri, 12 Sep 2008 12:08:04 -0400
Reply-To: Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject: Re: Export Data to Excel in Unix
There are several ways to bring data to EXCEL.
One is to export to a CSV file, e.g. with delimiter ";". The results are
not too nice, but the data should be readable in EXCEL.
What EXCEL can deal very good with, is HTML. Why don't you write your data
in a nice HTML report with ODS and read that in EXCEL? All the attributes,
colors, traffic lighting, ... are transported with that. You can even try
to exchange the extension HTML to XLS, so with a double click EXCEL is
opened instead of a browser.
If you really want pure data to EXCEL (what about column headers? EXCEL is
no DB, where do you know from, what the data should mean?), just take a
OPTIONS PS=9999 LS=250;
PROC PRINT data=... NOOBS; RUN;
On Fri, 12 Sep 2008 09:55:06 -0500, Mary <mlhoward@AVALON.NET> wrote:
>I don't have unix, but could you not export a file in XML rather than
>proc export? I find this keeps formatting much better, and an XML file
>should be able to be transferred across systems, because that is actually
>what it was designed to do.
>Here is an example; not sure how to translate it to UNIX, as it has been a
>ods listing close;
>ods tagsets.excelxp file='C:\Work_Activities\controls.xml'
>ods tagsets.excelxp options(sheet_name="Control Raw Data");
>title 'Controls Raw Data';
>proc print data=affymetrix_set;
>var sample_name disease_grouping1 disease_grouping2 glaucoma_group4
>ods tagsets.excelxp close;
>----- Original Message -----
>From: Kiran Nallapeta
>Sent: Friday, September 12, 2008 7:25 AM
>Subject: Export Data to Excel in Unix
>I need to export data from a dataset to an excel file using a SAS Job
>is running on a Solaris/Unix OS machine. Is there a way to do the same?
>As SAS Access to PC files doesnt exist for Unix machine, I tried to do the
>above using something like below...
>proc export data=application_master
>But what is happening when I am doing the above is.... its sometimes
>inserting a carriage return at the end / in between a particular record
>hence breaking those records to different lines. So is there a way I can
>export data to an excel file on Unix?
>Searching for the best deals on travel? Visit MSN Travel.