* [결측항목] 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;
