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?

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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