-------------------------------------------------------------------------------
       log:  /Volumes/ecxs2/users/baum/CompustatCompann/327xtdes2.smcl
  log type:  smcl
 opened on:  17 Jan 2008, 09:36:02


. use crspcompustat,clear

. todate date, gen(ymd) p(yyyymmdd)

. g ym=mofd(ymd)

. format ym %tm

. desc

Contains data from crspcompustat.dta obs: 1,609,123 vars: 13 20 Nov 2007 15:14 size: 104,592,995 (80.1% of memory free) ------------------------------------------------------------------------------- storage display value variable name type format label variable label ------------------------------------------------------------------------------- gvkey long %12.0g GVKEY npermno long %12.0g NPERMNO linkdt long %12.0g LINKDT linkenddt str8 %9s LINKENDDT cnum str6 %9s CNUM smbl str7 %9s SMBL date long %12.0g DATE prch float %9.0g prcl float %9.0g cshtrm float %9.0g cshoq float %9.0g ymd float %d __000001 ym float %tm ------------------------------------------------------------------------------- Sorted by: Note: dataset has changed since last saved

. tsset gvkey ym panel variable: gvkey (unbalanced) time variable: ym, 1990m1 to 2006m12, but with gaps delta: 1 month

. xtdes

gvkey: 1004, 1009, ..., 270705 n = 17396 ym: 1990m1, 1990m2, ..., 2006m12 T = 204 Delta(ym) = 1 month Span(ym) = 204 periods (gvkey*ym uniquely identifies each observation)

Distribution of T_i: min 5% 25% 50% 75% 95% max 1 9 36 81 140 204 204

Freq. Percent Cum. | Pattern* ---------------------------+-------------------------------------------------- ------------------------------------------------------- 2002 11.51 11.51 | 222222222222222222222222222222222222222222222222 > 222222222222222222222222222222222222222222222222222222 88 0.51 12.01 | 22222222222222222222222222221................... > ...................................................... 82 0.47 12.49 | ................................................ > ..................................................1222 77 0.44 12.93 | 222222222222222222222222222222222222222222222222 > 222222222222.......................................... 73 0.42 13.35 | 222222222222222222222222222222222222222222222222 > 22221................................................. 69 0.40 13.74 | 22222222222222222222222222222222222222222222221. > ...................................................... 66 0.38 14.12 | 22222222222222222222222222222222221............. > ...................................................... 63 0.36 14.49 | 22221........................................... > ...................................................... 63 0.36 14.85 | 222222222222222................................. > ...................................................... 14813 85.15 100.00 | (other patterns) ---------------------------+-------------------------------------------------- ------------------------------------------------------- 17396 100.00 | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX > XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ------------------------------------------------------------------------------ ------------------------------------------------------- *Each column represents 2 periods.



. log close log: /Volumes/ecxs2/users/baum/CompustatCompann/327xtdes2.smcl log type: smcl closed on: 17 Jan 2008, 09:41:15 -------------------------------------------------------------------------------