Hi everyone, could you please help me to use proc sql, create new variables (not macro) that will keep N, Mean, STD, Median, Min, Max of SALARY by LEAGUEs from sashelp.BASEBALL dataset. i tried this but seems i should have not use proc means; proc means data=sashelp.baseball; output out=baseball_1 N=N1 Mean=Mean1 STD=STD1 Median=Median1 Min=Min1 Max=Max1; class league; var salary; run; proc sql; create table baseball_2 as select League. *, N1 as N, Mean1 as Mean, STD1 as STD, Median1 as Median, Min1 as Min, Max1 as Max FROM baseball_1; quit;
... View more