Date: Fri, 19 Mar 2010 10:12:08 -0400
Reply-To: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject: Re: reading xls without proc import or changing file type
In-Reply-To: <b7a7fa631003181944ta8606fcnc219bf178ea65972@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"
Joe:
See http://support.sas.com/rnd/base/ods/excel/
S
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Joe Matise
Sent: Thursday, March 18, 2010 10:45 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: reading xls without proc import or changing file type
How? I'd love to see a paper on it if you have one handy...
-Joe
On Thu, Mar 18, 2010 at 9:43 PM, Sigurd Hermansen <HERMANS1@westat.com>wrote:
> 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.
> >
>
| 
