topic Re: How can I find the Min and Max of Column from EXCEL file? in Statistical Procedures

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

tasha89tp — Mon, 26 Sep 2016 19:29:51 GMT

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?

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

ballardw — Mon, 26 Sep 2016 21:22:04 GMT

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.