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

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

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

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.


Accepted Solutions
Solution
‎05-13-2014 01:51 AM
Trusted Advisor
Posts: 3,214

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

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.

Other solutions could be:  

- Use 64-bit Ms-office

- Transport your data using CSV or XML (do the conversion outside SAS / Office) 

- Go fo a server-approach wit AMO (Addin Microsoft Office)

It is a usual question. DBMS interfaces and many more are having the same kind of bit-ness issues.

http://www.linkedin.com/groupItem?view=&gid=70702&type=member&item=5869814871612235778&qid=d26176d7-...

---->-- ja karman --<-----

View solution in original post


All Replies
Solution
‎05-13-2014 01:51 AM
Trusted Advisor
Posts: 3,214

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

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.

Other solutions could be:  

- Use 64-bit Ms-office

- Transport your data using CSV or XML (do the conversion outside SAS / Office) 

- Go fo a server-approach wit AMO (Addin Microsoft Office)

It is a usual question. DBMS interfaces and many more are having the same kind of bit-ness issues.

http://www.linkedin.com/groupItem?view=&gid=70702&type=member&item=5869814871612235778&qid=d26176d7-...

---->-- ja karman --<-----
New Contributor
Posts: 4

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

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!

Super User
Posts: 10,035

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

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 2118 views
  • 0 likes
  • 3 in conversation