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.
@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.
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
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
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?
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.