Proc sort

ivethguzman — Mon, 16 Dec 2019 21:02:08 GMT

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.

Re: Proc sort

PaigeMiller — Mon, 16 Dec 2019 21:26:39 GMT

You don't need PROC SORT.

proc means data=totalyears n mean stderr;
    class year;
    var gpa;
run;

topic Re: Proc sort in SAS Procedures

Proc sort

Re: Proc sort