α   |  ȸ  |  Ʈ  |  Contact Us
  ̵ ϱ
 
Ȩ > SAS Tech & Tip > SAS
ó 2017.04.17
449 0
http://www.mysas.co.kr/SAS_tiptech/c_tiptech.asp?b_no=7251&gotopage=1&con=subject&keyword=&cmd=content&bd_no=07&gubun=%EB%8D%B0%EC%9D%B4%ED%84%B0%EA%B4%80%EB%A6%AC&%EC%B2%98%EB%A6%AC

 

ID Type_Code Gubun_Code
10066529 2 10
10066529 2 10
10066529 3 10
10111424 3 20
10111424 3 20
10131684 3 20
10131684 3 20
10131684 3 20


->

 

: Gubun_Code ̺          
  2   3     հ
̺ 10 20 10 30 20  
10066529 2   14   4 20
10111424         2 2
10131684         6 6
10145882     8   3 11
10212411     11     11
10215498     3     3
10243978     2     2
10277473     5     5
10287707       1   1
10300302     3   2 5
10323187         2 2
10333862         5 5
10343384   1 1   8 10
10349272     17     17
հ 2 1 64 1 32 100

 

 

type ID Gubun ̿Ƚ ϰ մϴ.

ID ȯؼ ۾ , ID 100,000 ʹ ũ ۾ ؾ ؼ SAS мϰ մϴ. ̷  ɾ ̿ؾ ϴ ǵ帳ϴ.

 

ã proc tabulate ε, ̰͵ sasδ ư excel exportؼ ߰ м ľ ߽ϴ. ϳ  noprintɼǵ ʾ ​output displayǴ ð ɸϴ. 

 

Ź帳ϴ.

 

 

 

 

 
  ty_2013.xlsx
ٿε | 2
    
ѳ   [2017/04/17 8:24]
proc sql 켱 Ͻ proc transpose ̿ؼ ġϽø ֽϴ.
  [2017/04/18 9:25]
ȳϼ 亯մϴ.

Ƿ Ͽ ֽ ظ ϰ ִ ü Ź帳ϴ.

ϱδ group by id count (type_code) count(gubun_cd) Ͽ id type code gubun_cd ġ϶ ǹ̷ Ǵ .

ƴϸ group by type_code gubun_code ϰ id ġ϶ ǹΰ Ǵ ̸ ϴ ǹ Ͻ ϰ ִ ϴ.

ŷοð ٽѹ ü Ź帳ϴ.

մϴ.
 
 ڰġ ˰մϴ.
 SAS 9.4 Ȯ θ â ʴ