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.
... View more