Programming the statistical procedures from SAS

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

Reply
New Contributor
Posts: 2

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

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? 

Super User
Posts: 10,871

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

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.

Ask a Question
Discussion stats
  • 1 reply
  • 140 views
  • 0 likes
  • 2 in conversation