Consider the following SAS statements in PROC SQL which generate a table HEIGHT_SUM from SASHELP.CLASS where the library SASHELP has been defined in SAS already.

By using Data Step, PROC SORT and PROC MEANS, rewrite the above SAS program to generate the same data set HEIGHT_SUM. [Note that a number of intermediate data sets may be produced and you are not required to remove them for simplicity.]

proc sql; create table height sum as select sex, age, count (*) as count, avg(height) as avg_height, min(height) as min_height, max (height) as max_height, std(height) as std_height from sashelp.class group by sex, age having avg(height) > 60; quit; proc sql; create table height sum as select sex, age, count (*) as count, avg(height) as avg_height, min(height) as min_height, max (height) as max_height, std(height) as std_height from sashelp.class group by sex, age having avg(height) > 60; quit