Joe: One can use SAS ODS to create MS Excel spreadsheets. An earlier version of SAS EG takes that route, though with marginal success. S

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Joe Matise Sent: Thursday, March 18, 2010 10:17 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: reading xls without proc import or changing file type

I don't think that would work. SAS ODS makes HTML or XML files. I'm not even sure if the libname engine can read that in...

I imagine that if it was TAGSETS.EXCELXP then you in theory could use an XML MAP to read it in with the XML libname engine. Never done it before or seen it done, but I don't see why it wouldn't be possible...

-Joe

On Thu, Mar 18, 2010 at 9:14 PM, Sigurd Hermansen <HERMANS1@westat.com>wrote:

> I would read this > "...ods generated xls file from sas that has been manipulated back into > sas..." > to mean that you have an xls spreadsheet file created by SAS ODS. > > I'd try a LIBNAME xxx Excel "<file name>.xls "; reference as step 1. > Unfortunately it refers essentially to a LIBRARY of worksheets. Each > worksheet may have a default name "Sheet<n>$", or an assigned name in the > Spreadsheet. You will have to display the Spreadsheet metadata to find the > actual name. Once you have the name of the worksheet, you'll be able to > refer to it as a member of Excel LIBRARY xxx under the SAS/Access Excel I/O > engine as > > .... select * from xxx.<name> ... > > If you don't have the SAS/Access Excel I/O engine licensed, you may have to > resort to converting each worksheet to a csv file and reading that into SAS. > > I have not found ODS access to MS Excel spreadsheets a reliable method ..., > S > > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of > Captain > Sent: Thursday, March 18, 2010 3:16 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: reading xls without proc import or changing file type > > I am trying to figure out a way to read an ods generated xls file from > sas that has been manipulated back into sas without using a proc > import or changing the file to csv or another file type. I am a can > not use any sas interactive features such as dde. Additionally I am > not sold on the output from sas to xls so if you have have a better > method that is ok as well. >