Hi,
so my files are like that :
..._paris_visites.20-10-08.csv
..._madrid_visites.20-10-08.csv
..._london_visites.20-10-08.csv
..._paris_events.20-10-08.csv
..._madrid_events.20-10-08.csv
..._london_events.20-10-08.csv
and i want to append and to have only 2 files like that :
..._visites.20-10-08.dta
..._events.20-10-08.dta
i found a loop to do that, but i need to do 1 loop for every type of documents (i don't have only visites and events but more)
For example for "visites" mine is :
local date_export="20-10-08"
clear
save ..._visites.`date_export'.dta, emptyok replace
local myfiles: dir "`pwd'" files "*visites.`date_export'.csv"
foreach x in `myfiles' {
import delimited "`x'", stringcols(_all) clear
gen Site= "`x'"
replace Site="Paris" if strpos(Site,"beni")
replace Site="Madrid" if strpos(Site,"butembo")
replace Site="London" if strpos(Site,"mangina")
append using ..._visites.`date_export'.dta
save ..._visites.`date_export'.dta,replace
}
It works, but i would like to get one loop (or 2, one in the other i never did it)
I would like to change "visites" by an other loop
I tried this but it doesn't work
local date_export="20-10-08"
local type_data="visites events"
foreach x of local `type_data' {
clear
save ..._`x'.`date_export'.dta, emptyok replace
local myfiles_`x' : dir "`pwd'" files "*`x'.`date_export'.csv"
foreach y in `myfiles_`x'' {
import delimited "`y'", stringcols(_all) clear
gen Site= "`y'"
replace Site="Paris" if strpos(Site,"paris")
replace Site="Madrid" if strpos(Site,"madrid")
replace Site="London" if strpos(Site,"london")
append using vainqueurs_`x'.`date_export'.dta
save vainqueurs_`x'.`date_export'.dta,replace
}
}
I have this error : { required r(100);
Ty !
Related Posts with Loop and files management with append
reshape the datasetHello I have the dataset as below. It is just one long row variable. I want to reshape using reshap…
bootstraping clustered standard errors in system GMM help!Hi guys, I am running a diff-in-diff fixed effects model with 16 countries between 2002 to 2017 test…
Foreach in mataDear All, just a quick question. Is it possible to use foreach within a mata function? Suppose I h…
Moderating effects in VAR possibleDear all, I am analyzing panel data covering 52 firms over one year and thinking about employing a …
Instrumental VariablesHello Experts, I am employing GMM approach on dynamic panel model. There are three endogenous variab…
Subscribe to:
Post Comments (Atom)
0 Response to Loop and files management with append
Post a Comment