topic Re: Can't save imported excel spreadsheet into Library in SAS University in SAS Programming

Can't save imported excel spreadsheet into Library in SAS University

ehuck22 — Sat, 21 Dec 2019 00:09:18 GMT

I am trying to do summary statistics on excel spreadsheet I have written the code and tried to save it to a library.

PROC IMPORT DATAFILE="/folders/myfolders/MIS445/MIS445_FRED-real_GDP.xlsx"
		    OUT=WORK.FRED
		    DBMS=XLSX
		    REPLACE;
RUN;

/** Print the results. **/


LIBNAME MIS445 "/folders/myfolders/MIS445;
data work.FRED;
	SET MIS445.FRED;

RUN;

I then go to the Task and Utilities section and click on the summary statistics. The Summary window tells me that I need to pick a data set from "MyLibraries" but my data set is not in there.

Second, I keep getting an error saying that there are no columns. Please help.

Re: Can't save imported excel spreadsheet into Library in SAS University

ballardw — Sat, 21 Dec 2019 00:24:16 GMT

@ehuck22 wrote:

I am trying to do summary statistics on excel spreadsheet I have written the code and tried to save it to a library.
PROC IMPORT DATAFILE="/folders/myfolders/MIS445/MIS445_FRED-real_GDP.xlsx"
		    OUT=WORK.FRED
		    DBMS=XLSX
		    REPLACE;
RUN;

/** Print the results. **/


LIBNAME MIS445 "/folders/myfolders/MIS445;
data work.FRED; <= The data set name here is the OUTPUT set, likely you meant the MIS445.Fred.
	SET MIS445.FRED; <= the data set here is the INPUT, likely the one created by Proc Import above

RUN;
I then go to the Task and Utilities section and click on the summary statistics. The Summary window tells me that I need to pick a data set from "MyLibraries" but my data set is not in there.

Second, I keep getting an error saying that there are no columns. Please help.

However depending on what actually happened you may have destroyed your work.fred and need to reimport it.

Re: Can't save imported excel spreadsheet into Library in SAS University

ehuck22 — Sat, 21 Dec 2019 01:11:06 GMT

I reimported the data and am now trying to get summary statistics. I get this error message

/*
 *
 * Code cannot be generated because the following 
 * roles are not set: 
 *
 *  Analysis variables: (minimum: 1)
 *
 *
 */ How do I add a variable

Re: Can't save imported excel spreadsheet into Library in SAS University

ChrisNZ — Sat, 21 Dec 2019 04:50:01 GMT

Your code makes no sense:

1. You create table WORK.FRED twice, so the first version (created from the excel data) is overwritten

2. I see no analysis performed in that code. How do you summarise?

Re: Can't save imported excel spreadsheet into Library in SAS University

ghosh — Sun, 22 Dec 2019 00:26:13 GMT

LIBNAME MIS445 "/folders/myfolders/MIS445;

PROC IMPORT DATAFILE="/folders/myfolders/MIS445/MIS445_FRED-real_GDP.xlsx"
		    OUT= MIS445.FRED;
		    DBMS=XLSX
		    REPLACE;
RUN;

Just import the excel file right into a permanent dataset in the stored in the location pointed to by MIS445 and then start your summary statistics