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.
You don't need PROC SORT.
proc means data=totalyears n mean stderr;
class year;
var gpa;
run;
You don't need PROC SORT.
proc means data=totalyears n mean stderr;
class year;
var gpa;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.