-
Notifications
You must be signed in to change notification settings - Fork 0
/
9_19.do
executable file
·68 lines (51 loc) · 1.82 KB
/
9_19.do
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
// merge all six counties' exported csv files to produce model zone aggregated results
// lots of "clear" command were used.
clear
log close _all
log using 9_19_mz, replace
local land_use public retail transportation /*warehousing*/ industrial other_commercial
local county Imperial Los_angeles Orange Riverside San_Bernardino Ventura
foreach var of local land_use {
foreach cvar of local county {
cd "D:/summer, 2011/Second Project/practice/Six counties/`cvar'"
insheet using "9_18_`var'.csv", clear
duplicates drop mz , force
gen mz_str = string(mz)
replace mz_str = "0_`cvar'" if mz_str == "0"
keep mz_str vsq_mz rsq_mz
cd "D:/summer, 2011/Second Project/practice/Six counties/append_mz"
save 9_19_`var'`cvar'.dta, replace
clear
}
}
foreach var of local land_use{
foreach cvar of local county {
append using 9_19_`var'`cvar'.dta
}
outsheet using "9_19_`var'.csv", comma
clear
}
// for warehousing, only OR,LA,VT are available
clear
local land_use warehousing
local county Los_angeles Orange Ventura
foreach var of local land_use {
foreach cvar of local county {
cd "D:/summer, 2011/Second Project/practice/Six counties/`cvar'"
insheet using "9_18_`var'.csv", clear
duplicates drop mz , force
gen mz_str = string(mz)
replace mz_str = "0_`cvar'" if mz_str == "0"
keep mz_str vsq_mz rsq_mz
cd "D:/summer, 2011/Second Project/practice/Six counties/append_mz"
save 9_19_`var'`cvar'.dta, replace
clear
}
}
foreach var of local land_use{
foreach cvar of local county {
append using 9_19_`var'`cvar'.dta
}
outsheet using "9_19_`var'.csv", comma
clear
}