Aggregating dataset to an upper level

halladje — Thu, 18 Jul 2019 18:12:37 GMT

Hello!

I have a dataset of students within classrooms within schools. I am trying to create a dataset that is at the class level from the student level file (i.e. aggregate student scores - 1 variables for one classroom).

I have created all my aggregated classroom variables with the following code (retaining student variables only at the class level, teacher variables which are by nature at the class level, and upper school level variables only):

proc sql;
create table teacher_is as
select x_idschool, x_class_id, t_selprog, t_female, t_sel,
mean(js_Sel) as js_sel_c, mean (j_int) as j_int_c, mean (j_ext) as j_ext_c,
mean (j_pared2) as j_pared2_c, mean (s_ageyrs) as age_c, mean(s_female) as fem_c,
TSSA11, TSSA14, TSSA19, TSSA111, TSSA113,
t_grade, t_imm, t_nonwhite,
t_com_elem6_12, t_ef,t_std_behav, t_clasS_pbs, t_sel_mean,
js_Sel_m, t_selprog_m, median, enrol, sch_lvl_Sec
from is_agg
group by x_idschool, x_class_id;
quit;

However, my output dataset still has a sample size at the student level. In SPSS you can aggregate up - whereby you have one observation for one class. Is there a way to do this in SAS?

Thanks so much,

Jillian

Re: Aggregating dataset to an upper level

PaigeMiller — Fri, 19 Jul 2019 10:56:39 GMT

I would use PROC SUMMARY and not PROC SQL to do this, but in either case, in order to advise you properly, we would need to see a small portion of your input data set, provided according to these directions: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

topic Re: Aggregating dataset to an upper level in Statistical Procedures

Aggregating dataset to an upper level

Re: Aggregating dataset to an upper level