Is there anyone who can help me create a loop from this:
set more off
clear all
foreach x of numlist 2/3 6 {
*display `x'
odbc load, table("individus") noquote ///
conn("DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=localhost;DATABASE=enq_tab_00`x';UI D=Christophe;PWD=Christmaevahope;") clear
save "D:\FTHM_DEP_RDC\LISUNGI\RSU\WAMPSERVER\enq_tab\in dividus_enq_tab_00`x'.dta", replace
}
*
foreach x of numlist 12 23 27 53 58 60 64 71 79 82 85 87 90 98 {
*display `x'
odbc load, table("individus") noquote ///
conn("DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=localhost;DATABASE=enq_tab_0`x';UID =Christophe;PWD=Christmaevahope;") clear
save "D:\FTHM_DEP_RDC\LISUNGI\RSU\WAMPSERVER\enq_tab\in dividus_enq_tab_0`x'.dta", replace
}
*
foreach x of numlist 100 108 116 127 134 142 {
*display `x'
odbc load, table("individus") noquote ///
conn("DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=localhost;DATABASE=enq_tab_`x';UID= Christophe;PWD=Christmaevahope;") clear
save "D:\FTHM_DEP_RDC\LISUNGI\RSU\WAMPSERVER\enq_tab\in dividus_enq_tab_`x'.dta", replace
}
Please help me, please.
Related Posts with Request for help
Multilevel modelling using “svy:melogit” with the ‘subpop’ option giving weird resultsI did my modelling using “svy:melogit” with the ‘subpop’ option in Stata 15.1 as follows after readi…
PPMLHDFE Gravity model for remittancesDear Tom Zylkin and Joao Santos Silva I hope you are doing well, I am using a gravity model in the …
Labels (Abc) from variable names (Abc_defghi)Hi all, I've seen a few posts asking questions about labelling variables by their respective names,…
how to count the number of variables after split?Dear All, How to generate a new variable that equals the number of variables generated after split?…
error in running mi impute chainedThank you very much in advance for reading this post, and for any help that you can extend. I am tr…
Subscribe to:
Post Comments (Atom)
0 Response to Request for help
Post a Comment