topic Re: Excel file uploaded cannot be open beacause it contains no column in New SAS User

Excel file uploaded cannot be open beacause it contains no column

Aduragbemi — Wed, 14 Aug 2019 09:55:35 GMT

After uploading and importing my excel file, SAS says it contains no column. what does this mean and how can i rectify this. I have searched for possible solution but to no avail. It quite getting frustrating as i cant find a way to resolve this and am just starting to learn SAS

Re: Excel file uploaded cannot be open beacause it contains no column

PeterClemmensen — Wed, 14 Aug 2019 10:14:15 GMT

How did you import the Excel file?

Re: Excel file uploaded cannot be open beacause it contains no column

Aduragbemi — Wed, 14 Aug 2019 10:25:00 GMT

I used snippet procedure and then inputted the file location

Re: Excel file uploaded cannot be open beacause it contains no column

Aduragbemi — Wed, 14 Aug 2019 10:39:05 GMT

First i uploaded the file to the sasuser v.94 and then i used the following code above to import it.

Re: Excel file uploaded cannot be open beacause it contains no column

Reeza — Wed, 14 Aug 2019 15:04:21 GMT

Attach the excel file please. Your file likely has issues.

Please post your code and log directly to the forum, pictures are hard to read and more work for you.

@Aduragbemi wrote:

First i uploaded the file to the sasuser v.94 and then i used the following code above to import it.

Re: Excel file uploaded cannot be open beacause it contains no column

Aduragbemi — Thu, 15 Aug 2019 08:26:30 GMT

The excel file is uploaded.

This was the code i used to to import the excel file

PROC IMPORT DATAFILE="/folders/myfolders/sasuser.v94/wheat.xlsx/"
		    OUT=WORK.Data
		    DBMS=XLSX
		    REPLACE;
RUN;

/** Print the results. **/

PROC PRINT DATA=WORK.data; RUN;

After importing the excel file then i created a library called tutor with this code

libname tutor "/folders/myfolders/";

After that i wanted to save the excel file i named data into the library with this code and after running it it brought out a message saying: "The table "TUTOR.DATA" cannot be opened because it does not contain any columns."

libname tutor "/folders/myfolders/";
data tutor.data;

Re: Excel file uploaded cannot be open beacause it contains no column

Tom — Thu, 15 Aug 2019 13:50:58 GMT

You have code to create WORK.TUTOR from your XLSX file. (What's with the slash after the end of the filename in the PROC IMPORT code? Didn't that cause an error? An XLSX file is not a directory.)

But you don't have any code to create TUTOR.DATA, other than the last line of code which looks like it is starting to generate a data step to make that dataset, but you are missing the rest of the data step. If you wanted to run a data step the read from WORK.TUTOR and wrote to TUTOR.DATA you would need to also add at least a SET statement and a RUN statement. Note if you just use a single level name SAS will assume you mean the use the WORK library.

data tutor.data;
  set tutor;
run;

Re: Excel file uploaded cannot be open beacause it contains no column

Aduragbemi — Sat, 17 Aug 2019 11:07:06 GMT

thanks so much. the issue has been resolved