Help using Base SAS procedures

SAS and Windows 2007

Reply
Contributor
Posts: 32

SAS and Windows 2007

Does someone has some experience importing excel files (Windows 2007) in SAS, from which version onward are they recognized?
Thanks for you help.
Coba
Super Contributor
Super Contributor
Posts: 3,174

Re: SAS and Windows 2007

Posted in reply to Proccontents
Check out the SAS support website http://support.sas.com/ - also:

SAS 9.2 DOC on the topic:

http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a003102095.htm


And, from the forum archives, a prior post on Excel 2007 / Office 2007 (not really Windows 2007):

http://support.sas.com/forums/thread.jspa?threadID=1938


Scott Barry
SBBWorks, Inc.
Contributor
Posts: 32

Re: SAS and Windows 2007

Well I have sas 9.1.3 and I would like to import an excel file *.xlsx file, but so far I haven't being able to import this type of file.
Is there something special I have to do? a add-in?
I hope someone who has experienced this, could be able to help me.
Thanks
coba
N/A
Posts: 0

Re: SAS and Windows 2007

Just re-save your xlsx file as xls (an option within the save command). SAS 9.1 will then recognize the file.
Occasional Contributor
Posts: 7

Re: SAS and Windows 2007

We are on 9.1 ship event 37 which is supposed to support MS Office 2007.
We are finding that we still need to save the Excel files as either .xls or as CSV (comma separated value) files in order to import them properly into Enterprise Guide.
Is this the experience of others as well?
Ask a Question
Discussion stats
  • 4 replies
  • 151 views
  • 0 likes
  • 4 in conversation