This does the job, I think. I suspect there's
a neater way.
su ccode, meanonly
set obs `r(max)'
gen WEIGHT = 0
gen CCODE = _n
count if ccode < .
qui forval i = 1/`r(N)' {
replace WEIGHT = weight[`i'] in `=ccode[`i']'
}
. l
+---------------------------------+
| ccode weight WEIGHT CCODE |
|---------------------------------|
1. | 6 .33 0 1 |
2. | 10 .036 0 2 |
3. | 11 .005 0 3 |
4. | 181 .004 0 4 |
5. | 182 1 0 5 |
|---------------------------------|
6. | . . .33 6 |
7. | . . 0 7 |
8. | . . 0 8 |
9. | . . 0 9 |
10. | . . .036 10 |
|---------------------------------|
11. | . . .005 11 |
12. | . . 0 12 |
13. | . . 0 13 |
14. | . . 0 14 |
15. | . . 0 15 |
|---------------------------------|
16. | . . 0 16 |
17. | . . 0 17 |
18. | . . 0 18 |
19. | . . 0 19 |
20. | . . 0 20 |
|---------------------------------|
21. | . . 0 21 |
22. | . . 0 22 |
23. | . . 0 23 |
24. | . . 0 24 |
25. | . . 0 25 |
|---------------------------------|
26. | . . 0 26 |
27. | . . 0 27 |
28. | . . 0 28 |
29. | . . 0 29 |
30. | . . 0 30 |
|---------------------------------|
31. | . . 0 31 |
32. | . . 0 32 |
33. | . . 0 33 |
34. | . . 0 34 |
35. | . . 0 35 |
|---------------------------------|
36. | . . 0 36 |
37. | . . 0 37 |
38. | . . 0 38 |
39. | . . 0 39 |
40. | . . 0 40 |
|---------------------------------|
41. | . . 0 41 |
42. | . . 0 42 |
43. | . . 0 43 |
44. | . . 0 44 |
45. | . . 0 45 |
|---------------------------------|
46. | . . 0 46 |
47. | . . 0 47 |
48. | . . 0 48 |
49. | . . 0 49 |
50. | . . 0 50 |
|---------------------------------|
51. | . . 0 51 |
52. | . . 0 52 |
53. | . . 0 53 |
54. | . . 0 54 |
55. | . . 0 55 |
|---------------------------------|
56. | . . 0 56 |
57. | . . 0 57 |
58. | . . 0 58 |
59. | . . 0 59 |
60. | . . 0 60 |
|---------------------------------|
61. | . . 0 61 |
62. | . . 0 62 |
63. | . . 0 63 |
64. | . . 0 64 |
65. | . . 0 65 |
|---------------------------------|
66. | . . 0 66 |
67. | . . 0 67 |
68. | . . 0 68 |
69. | . . 0 69 |
70. | . . 0 70 |
|---------------------------------|
71. | . . 0 71 |
72. | . . 0 72 |
73. | . . 0 73 |
74. | . . 0 74 |
75. | . . 0 75 |
|---------------------------------|
76. | . . 0 76 |
77. | . . 0 77 |
78. | . . 0 78 |
79. | . . 0 79 |
80. | . . 0 80 |
|---------------------------------|
81. | . . 0 81 |
82. | . . 0 82 |
83. | . . 0 83 |
84. | . . 0 84 |
85. | . . 0 85 |
|---------------------------------|
86. | . . 0 86 |
87. | . . 0 87 |
88. | . . 0 88 |
89. | . . 0 89 |
90. | . . 0 90 |
|---------------------------------|
91. | . . 0 91 |
92. | . . 0 92 |
93. | . . 0 93 |
94. | . . 0 94 |
95. | . . 0 95 |
|---------------------------------|
96. | . . 0 96 |
97. | . . 0 97 |
98. | . . 0 98 |
99. | . . 0 99 |
100. | . . 0 100 |
|---------------------------------|
101. | . . 0 101 |
102. | . . 0 102 |
103. | . . 0 103 |
104. | . . 0 104 |
105. | . . 0 105 |
|---------------------------------|
106. | . . 0 106 |
107. | . . 0 107 |
108. | . . 0 108 |
109. | . . 0 109 |
110. | . . 0 110 |
|---------------------------------|
111. | . . 0 111 |
112. | . . 0 112 |
113. | . . 0 113 |
114. | . . 0 114 |
115. | . . 0 115 |
|---------------------------------|
116. | . . 0 116 |
117. | . . 0 117 |
118. | . . 0 118 |
119. | . . 0 119 |
120. | . . 0 120 |
|---------------------------------|
121. | . . 0 121 |
122. | . . 0 122 |
123. | . . 0 123 |
124. | . . 0 124 |
125. | . . 0 125 |
|---------------------------------|
126. | . . 0 126 |
127. | . . 0 127 |
128. | . . 0 128 |
129. | . . 0 129 |
130. | . . 0 130 |
|---------------------------------|
131. | . . 0 131 |
132. | . . 0 132 |
133. | . . 0 133 |
134. | . . 0 134 |
135. | . . 0 135 |
|---------------------------------|
136. | . . 0 136 |
137. | . . 0 137 |
138. | . . 0 138 |
139. | . . 0 139 |
140. | . . 0 140 |
|---------------------------------|
141. | . . 0 141 |
142. | . . 0 142 |
143. | . . 0 143 |
144. | . . 0 144 |
145. | . . 0 145 |
|---------------------------------|
146. | . . 0 146 |
147. | . . 0 147 |
148. | . . 0 148 |
149. | . . 0 149 |
150. | . . 0 150 |
|---------------------------------|
151. | . . 0 151 |
152. | . . 0 152 |
153. | . . 0 153 |
154. | . . 0 154 |
155. | . . 0 155 |
|---------------------------------|
156. | . . 0 156 |
157. | . . 0 157 |
158. | . . 0 158 |
159. | . . 0 159 |
160. | . . 0 160 |
|---------------------------------|
161. | . . 0 161 |
162. | . . 0 162 |
163. | . . 0 163 |
164. | . . 0 164 |
165. | . . 0 165 |
|---------------------------------|
166. | . . 0 166 |
167. | . . 0 167 |
168. | . . 0 168 |
169. | . . 0 169 |
170. | . . 0 170 |
|---------------------------------|
171. | . . 0 171 |
172. | . . 0 172 |
173. | . . 0 173 |
174. | . . 0 174 |
175. | . . 0 175 |
|---------------------------------|
176. | . . 0 176 |
177. | . . 0 177 |
178. | . . 0 178 |
179. | . . 0 179 |
180. | . . 0 180 |
|---------------------------------|
181. | . . .004 181 |
182. | . . 1 182 |
+---------------------------------+
. log close
log: c:\ado\personal\uk04grtalk\dubas.log
log type: text
closed on: 28 Jul 2004, 23:22:23
--------------------------------------------------------------------------------
Nick
[email protected]
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]]On Behalf Of
> [email protected]
> Sent: 28 July 2004 22:59
> To: STATA list
> Subject: st: Data manipulation question
>
>
> Hello,
> I have an excel file that looks something like this:
> ccode weight
> 6 .33
> 10 .036
> 11 .005
> 181 .004
> 182 1
>
> What I need to do is have ccode from 1 to 182, and weight to
> be 0(zero) if there
> is not already a value in my excel file. So, I hope to have
> something like
> this in the end:
>
> ccode weight
> 1 0.00
> 2 0.00
> etc.
> 6 .33
> 7 0.00
> etc.
> 182 1
>
> Any suggestion?
> Thanks,
> Justin
>
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
