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/