Date: Fri, 12 Sep 2008 09:55:06 -0500
Reply-To: Mary <firstname.lastname@example.org>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Mary <mlhoward@AVALON.NET>
Subject: Re: Export Data to Excel in Unix
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
I don't have unix, but could you not export a file in XML rather than using
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 which
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.