STATA notes *------------------------------------------------------------------------------------------ bysort id (year): gen cumx = sum(X) *------------------------------------------------------------------------------------------ collapse (mean) avgage=age avgt=t (count) numkid=birth, by(famid) *------------------------------------------------------------------------------------------ bys hhid: egen mean_x50_1 = mean(x) if age > 50 bys hhid: egen mean_x50_2 = mean(x / (age > 50)) bys hhid: egen mean_x50_3 = mean(cond(age > 50, x, .)) last two identical consequences (the first only puts results in observations it uses) egen nsisters=total(age<18 & sex==1), by(fam) egen mean_Wage=mean(age / (gender==1)), by(co year) by foreign, sort: egen mean_weight_3 = mean(cond(mpg > 25, weight, .)) *------------------------------------------------------------------------------------------ table foreign region, c(mean age sd age) format(%9.2f) center row col *------------------------------------------------------------------------------------------ reshape collapse graphs 2 scatterplots color symbols *------------------------------------------------------------------------------------------ putexcel set putexcel2.xlsx, sheet(example6) modify putexcel B1 = matrix(AA), names nformat(number_d2) *------------------------------------------------------------------------------------------ 'SAVE POST REG qui replace t_test=_b[ret_mkt]/_se[ret_mkt] *------------------------------------------------------------------------------------------ 'LOOP *foreach t of numlist 1 6 12 24 36 { foreach v in college degree major { capture confirm variable `v' if !_rc { forvalues vv=1(1)3 { gen `v'_`vv' =. } } } *------------------------------------------------------------------------------------------ capture reg ri rm, r if c(rc) == 0 { // REG WENT WELL reg ri rm. r } *------------------------------------------------------------------------------------------ tokenize beta size mtbv mom forvalues i=1(1)4 { reg ret ``i'' } *------------------------------------------------------------------------------------------ foreach num of numlist 1999/2016 { append using `num' } *------------------------------------------------------------------------------------------ 'SAVE POST REG qui reg price c.mpg##c.weight##c.weight i.foreign qui margins , at(foreign=0 mpg=(1 2 3)) over(weight) *------------------------------------------------------------------------------------------ sort name age sex quietly by name age sex: gen dup = cond(_N==1,0,_n) *------------------------------------------------------------------------------------------ g mydate = date(code, "DMY") form mydate %td *------------------------------------------------------------------------------------------ *from ds to stata *http://www.princeton.edu/~otorres/Stata/Reshape *--------------------------------- *rows=>dscode_types *cols=>dates ************ replace code = subinstr(code,"(","_",.) replace code = subinstr(code,")","",.) *sort code *qui by code: gen dup = cond(_N==1,0,_n) reshape long _, i(code) j(dates) string *-------- *DPS;DT;DY;PYD;XDD split code, p("_") drop code rename code1 code rename code2 datatype order code dates datatype * egen id2 = group(code dates) order id2 code dates datatype drop name reshape wide _, i(id2) j(datatype) string order id2 code dates drop id2 *------------------------------------------------------------------ cd "C:\Users\stefano.mengoli\Desktop\LL" *--------------------------------- local allfiles : dir . files "*.xls" di `allfiles' foreach file in `allfiles' { import excel using "`file'", firstrow sheet("Export Data") clear local noextension=subinstr("`file'",".xls","",.) local noextension= subinstr("`noextension'", " ", "",.) save "`noextension'", replace gen ticker="`noextension'" save "`noextension'", replace } *---------------------------------MASTER: one file local statfiles : dir . files "*.dta" clear local i=1 gen blankvar=. save MASTER, replace foreach data in `statfiles' { use MASTER, clear append using `data' save MASTER, replace di `i' local i=`i'+1 } drop blankvar save MASTER, replace *----------------------------------------------------------------- *-------------------------bunch of csvs---------------------- *----------------------------------------------------------------- clear forval yy=2018(1)2019 { local s="C:\Users\stefano.mengoli\Desktop\FF\serie\"+"`yy'" cd "`s'" local satafiles: dir . files "*.csv" foreach file of local satafiles { preserve qui import delimited using `file', clear stringcols(_all) qui g csv= regexr(regexr("`file'", ".csv",""), ".*_", "") qui g year=`yy' qui save temp,replace restore qui append using temp, force } } *-------------------------------------------- gr hbar car, /// over(cous, sort(1) desc label(labsize(tiny) angle(0))) ytitle(CAR) /// bar(1, fcolor(red)) /// plotregion(fcolor(white)) /// graphregion(fcolor(white)) nofill /// aspectratio(1) saving(2,replace) |
Click here to edit.
VBA
for i=1 to iter next *------------- Do loop until cells(i,j)="" R Tabs<- rbind(T1, T2) Tabs<- cbind(T1, T2) PYTHON |