Here is what I have to do: Using the “schools1” data, create a new dataset called "schools2" which includes average and median sat scores for sat1, sat2, sat3, and overall satavg with school as the level of analysis. If you do this correctly, there should be 30 observations and 11 variables (including 8 different SAT variables) in your resulting dataset (use PROC MEANS to do this). So I think I have to basically get rid of the student variable and just have one row per school, but im really not sure how to do that using proc means, I've been trying for a couple hours but don't even really know where to start. I added some of the code to make the data and a picture of the schools1 dataset.
... View more