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
SFA with sf_modelhi everyone, I met one problem when I use the SFA model to calculate the TFP. I am very grateful if …
estat icc reporting of Intra-cluster correlation in three-level linear regression (mixed) different from manually calculation...Hi, I'm analyzing a three-level model I've run with mixed. It produces the following table for the …
preserve / restore through a do fileHello, it seems as if the commands preserve and restore don't function properly when they're execut…
Regression with double loop (chaning dependent and independent)Hi, i want to do a multiple regression on times series of 100 corporates. The problem is that not j…
Clustering TendencyDear Stata Users, I want to evaluate the clustering tendency of my data set consisting of the observ…
Subscribe to:
Post Comments (Atom)
0 Response to Loop and files management with append
Post a Comment