09-26-2016 03:29 PM
I imported the EXCEL file, but my code is not working:
PROC IMPORT DATAFILE = 'C:\Users\Tasha\Desktop\SASGraphs\diving.xlsx' DBMS = XLSX OUT = scores;
PROC PRINT DATA = scores;
TITLE 'SAS Data Set Read From Excel File for Diving';
PROC REPORT DATA = diving.xlsx NOWINDOWS;
COLUMN Name,(Score1 Score2), MEAN;
COLUMN Name, (MIN MAX) (Score1 Score2);
TITLE 'The overall minimum, maximum, and mean of Score1 and Score2';
What is wrong with the code?
09-26-2016 05:22 PM
It looks like the file you input went to OUT = scores so reference it as SCORES if the code worked.
Your Proc Repot has data=diving.xlsx which would say to look at LIBRARY named "diving" and a dataset name "xlsx".
If you want to use the set that you import then use DATA=SCORES.
Do you get any errors? Show the results from the log;
Unexpected output the output and the desired output.