|
Joe,
The JET Engine is deprecated. SAS needs to switch to a new engine and move
off of JET.
Alan
Alan Churchill
Savian
www.savian.net <http://www.savian.net/>
From: Joe Matise [mailto:snoopy369@gmail.com]
Sent: Wednesday, December 10, 2008 10:26 AM
To: Alan Churchill
Cc: SAS-L@listserv.uga.edu
Subject: Re: FYI - 64-bit nuance of Proc Export
According to this:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID
=125117
JET drivers do not (and will not) exist for Windows x64.
Thus, SAS elements like the LIBNAME engine for Excel/Access will not work in
x64, apparently?
-Joe
On Wed, Dec 10, 2008 at 11:08 AM, Alan Churchill <savian001@gmail.com>
wrote:
Ron,
32 bit apps should run under Vista 64. People run Office under 64 bit Vista.
Alan
Alan Churchill
Savian
www.savian.net
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Fehd,
Ronald J. (CDC/CCHIS/NCPHI)
Sent: Wednesday, December 10, 2008 9:47 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: FYI - 64-bit nuance of Proc Export
Fire-Giver!
welcome back, dude!
this is a known problem with Win x64:
that it cannot handle Excel files.
The short, condensed, response from Tech Support is:
"uh,
more Unix-like
means less native Windows apps."
Q: can you run Excel under Vista 64?
Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov
> -----Original Message-----
> From: owner-sas-l@listserv.uga.edu
> [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of William W.
> Viergever
> Sent: Tuesday, December 09, 2008 8:33 PM
> To: sas-l@uga.edu
> Subject: FYI - 64-bit nuance of Proc Export
>
> dudes & dudettes:
>
> although i've had it installed on my 64-bit Vista laptop for months, i
> just got around to installing 64-bit SAS v9.2 on my XP x64
> desktop/workstation...
>
> then, later today
>
> ran a job that ends w/ a Proc Export to a new Excel file
>
> in my Proc Export code
>
> DBMS = EXCEL2000 generated an error
>
> ditto for DBMS = EXCEL2003, and for plain ole = EXCEL
>
> searching through the Proc Export docs, i noticed a really-fine-print
> comment that the = EXCEL???? identifiers only hold for libname access
>
> so ... i then tried DBMS = XLS and
>
> voila! ... all is cool
>
> so ... inquiring minds wann know:
>
> is the fact that = EXCEL worked under 32-bit SAS a quirk, or did they
> do something new/diff in 64-bit SAS?
>
> ciao' for now,
>
> out
>
>
|