topic Re: problem to import XLSX file into SAS in SAS Programming

problem to import XLSX file into SAS

Ronein — Thu, 05 Aug 2021 11:30:22 GMT

Hello

I have XLSX Excel file with 1 columns with following data: (I put example of the data)

I am trying to import the XLSX file into SAS using file import wizard.

I get an error and I am not able to import it!

What step should I do please?

118 ,  201 ,  304 , 
301 ,  333 , 
333 , 
0 ,  308 , 
0 ,  304 , 
304 , 
118 ,  201 ,  308 , 
0 ,  118 ,  201 ,  333 , 
118 ,  201 ,  304 ,

Re: problem to import XLSX file into SAS

Kurt_Bremser — Thu, 05 Aug 2021 11:44:40 GMT

Use the XLSX engine to access the file, not EXCEL or similar.

If in doubt, post the code you tried to import the file.

Re: problem to import XLSX file into SAS

ballardw — Thu, 05 Aug 2021 14:32:18 GMT

One of the wonderful joys of working with Microsoft Office software like Excel is that the specific engines for accessing data critical. If you use an option that is intended to work with older files on a newer file format you get such errors because the underlying files are considerable different.

You have to know which option goes with which file format. Read the Proc Import documentation carefully. There are tables with multiple file related options and which file formats they work with.

Or save yourself a lot of headaches with fixing data later by saving the XLSX to CSV and read that.