DATA Step, Macro, Functions and more

Ofice 2007

Reply
N/A
Posts: 0

Ofice 2007

Does anyone know if SAS plans to add Excel/Access 2007 to the list of Proc Import/Export options? I know you can "save as" in 2003 format, but it would be easier to work directly with the 2007 files.
SAS Super FREQ
Posts: 8,868

Re: Ofice 2007

Posted in reply to deleted_user
Hi:
These Tech Support notes seem to point to a direction:

http://support.sas.com/kb/4/484.html says that EG won't support .xlsx for import
http://support.sas.com/kb/19/774.html says you can use SAS/Access for OLE-DB

cynthia
Frequent Contributor
Posts: 127

Re: Ofice 2007

Posted in reply to deleted_user
Hello,

Proc import will support the .xlsx format with the SAS 9.2 Release 2.
I got this information from the SAS technical support (Belgium). It's foreseen for beginning of 2009.

Regards,
Florent
Ask a Question
Discussion stats
  • 2 replies
  • 128 views
  • 0 likes
  • 3 in conversation