·Î±×ÀÎ   |  È¸¿ø°¡ÀÔ  |  »çÀÌÆ®¸Ê  |  Contact Us
  ¾ÆÀ̵ð ÀúÀåÇϱâ
 
Ȩ > SAS Tech & Tip > SAS °í¼ö
[°áÃøÇ׸ñ] ZERO(°áÃø°ª) °ª¿¡ ÇØ´çÇÏ´Â Ç׸ñ(¹üÁÖ) Ãâ·ÂÇϱâ 2017.06.08
¹é½Â¹Î 489 0
http://www.mysas.co.kr/SAS_tiptech/a_all.asp?b_no=7319&gotopage=1&con=subject&keyword=&cmd=content&bd_no=33&gubun=

 

* [°áÃøÇ׸ñ] 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;

 

 
 
 
 
 [SAS Format] SAS¿¡¼­ Áö¿øÇÏ´Â Ãâ·Â Çü½Ä ¸®½ºÆ® ¹× ¿¹Á¦(20170613)
 [»ö»óÇ¥] SAS¿¡¼­ Áö¿øÇÏ´Â »ö°ú »ö»ó¸í2