topic Re: How do I import 32bit excel sheet into a 64 bit sas 9.4 in SAS Programming

How do I import 32bit excel sheet into a 64 bit sas 9.4

ss123 — Tue, 13 May 2014 02:32:22 GMT

I have been trying to find ways to import my 32bit microsoft excel 2010 and I found the PC file server installation guide (SAS/ACCESS(R) 9.4 Interface to PC Files: Reference, Second Edition). However, it is a little confusing and I was wondering if any of you have done it and tell me about your experience.

My laptop is a windows 7.

Thanks.

Re: How do I import 32bit excel sheet into a 64 bit sas 9.4

jakarman — Tue, 13 May 2014 05:51:27 GMT

It is not that difficult, You need to install the 32-bit version of PCfiles-server.

Your SAS code need to be changed to using the tcpip connection to that PCfiles-server. By that it will go from a 64-bit to 32-bit process.

The technical reason it the ACE-driver being part of MS-office. That driver is doing all the conversions.

With xlsx files (Zip files containing XML files) this is not necessary any more, but SAS is still doing this.

Re: How do I import 32bit excel sheet into a 64 bit sas 9.4

ss123 — Tue, 08 Jul 2014 15:53:56 GMT

Thanks! It took me so long is because I didn't find any pc server file for sas 9.4, but now they have it!

Re: How do I import 32bit excel sheet into a 64 bit sas 9.4

Ksharp — Wed, 09 Jul 2014 13:00:08 GMT

You can make a ODBC connection for that excel file, But it would be cumbersome and clumsy .