How can I find the Min and Max of Column from EXCEL file?

[tasha89tp]

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;
RUN;
PROC PRINT DATA = scores;
TITLE 'SAS Data Set Read From Excel File for Diving';
RUN;
PROC REPORT DATA = diving.xlsx NOWINDOWS;
COLUMN Name,(Score1 Score2), MEAN;
COLUMN Name, (MIN MAX) (Score1 Score2);
DEFINE Name/GROUP;
TITLE 'The overall minimum, maximum, and mean of Score1 and Score2';
RUN;

What is wrong with the code? 

[ballardw]

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.