Import Excel File - 1 observation, 0 variables

[lvenner]

Hello! I am using a libname statement to import my xslx excel data into SAS.  When I run proc contents, it says I have 1observations and 0 variables.  How can I fix this? Is this a problem with my data or with how I am importing the data?

Thank you!

[PaigeMiller]

Look at the Excel file and see if there's an obvious reason why this happened.

Look at the SAS LOG to see if there are any error or warning messages.

[Reeza]

Without the code, log, error, file or anything it's anyone's guess.