Thanks, Reeza! Question, though: I tried correcting my code by specifying for SQL to join each table by the variable called "variable" as follows proc sql; create table estabgroup_table as select mean_estabgroupamp.variable, estabgroupamp, estabgroupsst, estabgroupnur, estabgrouphih, F, Prob, Pooledmean from mean_estabgroupamp as mea inner join mean_estabgroupsst as mes inner join mean_estabgroupnur as men inner join mean_estabgrouphih as meh inner join anova_estabgroup1 as an inner join pooledmean1 as pm on mea.variable eq mes.variable eq men.variable eq meh.variable eq a.variable eq pm.variable eq ; quit; proc print data=estabgroup_table; run; but did I do this incorrectly because I get the following log result?: 2900 proc sql; 2901 create table estabgroup_table as 2902 select mean_estabgroupamp.variable, 2903 estabgroupamp, 2904 estabgroupsst, 2905 estabgroupnur, 2906 estabgrouphih, 2907 F, 2908 Prob, 2909 Pooledmean 2910 from mean_estabgroupamp as mea inner join 2911 mean_estabgroupsst as mes inner join ----- 73 2912 mean_estabgroupnur as men inner join ----- 73 2913 mean_estabgrouphih as meh inner join ----- 73 2914 anova_estabgroup1 as an inner join ----- 73 ERROR 73-322: Expecting an ON. 2915 pooledmean1 as pm 2916 on mea.variable eq mes.variable eq men.variable eq meh.variable eq an.variable eq pm.variable eq 2916! ; 2916 on mea.variable eq mes.variable eq men.variable eq meh.variable eq an.variable eq pm.variable eq 2916! ; - 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER. 2917 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
... View more
