topic Re: Import Excel File - 1 observation, 0 variables in New SAS User

Import Excel File - 1 observation, 0 variables

lvenner — Wed, 26 Jun 2019 12:54:14 GMT

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!

Re: Import Excel File - 1 observation, 0 variables

PaigeMiller — Wed, 26 Jun 2019 12:57:19 GMT

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.

Re: Import Excel File - 1 observation, 0 variables

Reeza — Wed, 26 Jun 2019 15:07:29 GMT

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