Date:         Wed, 28 Oct 2009 18:01:23 -0700
Reply-To:     Savian <savian.net@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Savian <savian.net@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: ERROR: DBMS type EXCEL not valid for export????
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Oct 28, 7:41 am, snoopy...@GMAIL.COM (Joe Matise) wrote:
> I was thinking more along the lines of using the JET/ACE engines, which are
> Microsoft products; there could be licensing fees associated with that.
>
> -Joe
>
>
>
> On Mon, Oct 26, 2009 at 9:14 PM, Savian <savian....@gmail.com> wrote:
> > On Oct 26, 1:10 pm, snoopy...@GMAIL.COM (Joe Matise) wrote:
> > > Exporting to Excel directly through PROC EXPORT dbms=EXCEL is an extra
> > > license, yes (I presume due to using Microsoft technology?).  Run the
> > code:
> > > PROC SETINIT; RUN; and it will list the modules you have licensed.
>
> > > You can output data to excel in a few other ways if you don't have a
> > license
> > > for PCFILES, though.  I think DBMS=XLS might work, and if it doesn't,
> > then
> > > you can look at either:
> > > * CSV and then open it in excel and save as...
> > > * ODS TAGSETS.EXCELXP
> > > * Another intermediary output destination that is readable by excel
>
> > > -Joe
>
> > > On Mon, Oct 26, 2009 at 2:06 PM, Carol Thurman <erb...@langate.gsu.edu
> > >wrote:
>
> > > > I'm not sure, Joe.  We just purchased this license from SAS a few
> > months
> > > > ago - I just thought it came with it.  Is this an add-on that we will
> > have
> > > > to purchase?
>
> > > > Carol
>
> > > > >>> Joe Matise <snoopy...@gmail.com> 10/26/09 3:03 PM >>>
> > > > Do you have SAS/ACCESS for PC Files licensed?
> > > > [PROC SETINIT; RUN; ]
> > > > -Joe
>
> > > > On Mon, Oct 26, 2009 at 1:37 PM, Carol Thurman <erb...@langate.gsu.edu
> > > > >wrote:
>
> > > > > Hi All,
>
> > > > > Why do I keep getting the error message below when I try to export
> > data
> > > > to
> > > > > excel?
>
> > > > > Carol
>
> > > > > >>>> PROC EXPORT DATA= WORK.HSPAL
> > > > > >>>>           OUTFILE= "J:\PAL 2009\High School Reliability.xls"
> > > > > >>>>       DBMS=EXCEL REPLACE;
>
> > > > > >>>>>ERROR: DBMS type EXCEL not valid for export.- Hide quoted text -
>
> > > - Show quoted text -
>
> > I doubt if there are any licensing restrictions due to Microsoft. The
> > Excel file format is open source and has been for awhile.
>
> > Alan
> >http://www.savian.net- Hide quoted text -
>
> - Show quoted text -

I don't think it works that way and my reasoning is that SAS can
export on Unix as well as PCs. I doubt if JET runs on Unix.

Alan