Hello,
I am trying to get the output for the average GPS for every year from my dataset.
I tried proc sort, but can manage to get a correct output. I have the years from 2015-2019.
My code is as follows:
data temp;
infile '/folders/myfolders/MY SAS Files/Data/finaldata.txt';
input ID gpa hsrank act year;
label ID = 'Identification'
gpa = 'Grade-point average following freshman year'
hsrank = 'High school class rank as percentile'
act = 'ACT entrence examination score'
year = 'Calender year that freshman entered university';
run;
/***/
proc sort data = temp out = totalyears;
by year;
run;
/**
proc print data=totalyears;
run;
/***/
proc means data=totalyears n mean stderr;
var year;
run;
The output is:

I want the output to be the different years and the mean of gpa for each year.