BookmarkSubscribeRSS Feed
coba
Calcite | Level 5
Does someone has some experience importing excel files (Windows 2007) in SAS, from which version onward are they recognized?
Thanks for you help.
Coba
4 REPLIES 4
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.
coba
Calcite | Level 5
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
deleted_user
Not applicable
Just re-save your xlsx file as xls (an option within the save command). SAS 9.1 will then recognize the file.
bfolzblu
Calcite | Level 5
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?

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1280 views
  • 0 likes
  • 4 in conversation