LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2008, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 10 Dec 2008 10:44:57 -0700
Reply-To:   Alan Churchill <savian001@GMAIL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Alan Churchill <savian001@GMAIL.COM>
Subject:   Re: FYI - 64-bit nuance of Proc Export
Comments:   To: Joe Matise <snoopy369@gmail.com>
In-Reply-To:   <b7a7fa630812100925ve9e79a9j53b89ce5d7581b3e@mail.gmail.com>
Content-Type:   text/plain; charset="US-ASCII"

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 > >


Back to: Top of message | Previous page | Main SAS-L page