problem to import XLSX file into SAS

[Ronein]

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 , 

[Kurt_Bremser]

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

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

[ballardw]

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.