topic Re: proc import not working for excel files in SAS Programming

proc import not working for excel files

bits — Sat, 11 Feb 2017 07:40:17 GMT

Im using SAS 9.0 for practicing SAS tutorials.. as im trying to import .xlsx file using proc import but it shows log error.... I'd written something like...
Proc import datafile="C:/desktop/data.xlsx
Out=work.sample
Dbms=xlsx
Replace;
Getnames=yes;
Run;
Im using bit old sas version...is this a reason for showing error... If it is so then plz give me a solution for this so that i can import excel file easily...
Thanks in advance..

Re: proc import not working for excel files

Kurt_Bremser — Sat, 11 Feb 2017 08:03:26 GMT

9.0 is really very old and lacks any support for the newer xlsx format. The simplest ways is to save the Excel data as csv and import that with a data step.

Re: proc import not working for excel files

bits — Sat, 11 Feb 2017 08:00:48 GMT

I'd also done the same...just changed the extension of file from .xlsx to .csv but didn't worked out for me...is there any other possible solution for this..?

Re: proc import not working for excel files

Kurt_Bremser — Sat, 11 Feb 2017 08:04:39 GMT

Just renaming the file does nothing to change its contents and format. Save as csv from Excel.

Re: proc import not working for excel files

bits — Sat, 11 Feb 2017 08:09:57 GMT

How to do it..?

Re: proc import not working for excel files

Kurt_Bremser — Sat, 11 Feb 2017 08:11:49 GMT

In Excel, select File - Save as, and then the proper file format. Or use File - Export.