* [°áÃøÇ׸ñ] ZERO(°áÃø°ª) °ª¿¡ ÇØ´çÇÏ´Â Ç׸ñ(¹üÁÖ) Ãâ·ÂÇϱâ; data BACK; input gender eth count; datalines; 1 1 12 1 2 12 1 3 21 2 1 2 2 3 43 ; run; * completetypes ¿É¼Ç : CLASS Ç׸ñÀÇ °ª Ãâ·Â;
proc summary data = BACK completetypes nway; class gender eth; var count; output out=BACK1 sum=; run; proc means data = BACK completetypes; class gender eth; var count; run; * Ãâó : http://studysas.blogspot.kr/2009/10/dummy-dataset-or-sas-options-which-is.html; data demo ; input siteid $ sex $ race $ age ; cards; SITE1 M White 23 SITE1 F White 43 SITE1 M White 34 SITE2 M Black 21 SITE2 M White 56 SITE2 F Black 33 ; run; proc sort data=demo; by siteid; run; *Without any options in proc freq; proc freq data=demo noprint; table siteid*race /out=nooptions (drop=percent); run; *With Sparse option in proc freq; proc freq data=demo noprint; table siteid*race /sparse out=_sparse (drop=percent); run; *With Completetypes and preloadfmt options in proc means; proc format; VALUE $RACEF 'Asian'='Asian' 'Black'='Black' 'White'='White'; run; data demo; set demo; format race $racef.; run; * completetypes ¿É¼Ç : CLASS Ç׸ñÀÇ °ª Ãâ·Â; proc means data=demo completetypes noprint nway; class siteid race; output out =race1(where=(_stat_='N')rename=(_freq_=count) keep=siteid race _freq_ _stat_); run; * preloadfmt ¿É¼Ç : »çÀü¿¡ Á¤ÀÇµÈ FORMAT °ª ±âÁØÀ¸·Î Ç׸ñ Ãâ·Â; proc means data=demo completetypes noprint nway; class siteid race/preloadfmt; output out =race2(where=(_stat_='N')rename=(_freq_=count) keep=siteid race _freq_ _stat_); run;
|