I am having problems getting -fillin- to work on a dataset with a variable which takes a large number of values (32000).
My dataset has just 2 variables sex, and area (as string). No missing values.
. tab sex, mi
sex | Freq. Percent Cum.
------------+-----------------------------------
1 | 32,507 50.01 50.01
2 | 32,496 49.99 100.00
------------+-----------------------------------
Total | 65,003 100.00
so now I
. fillin sex soal
But after this I have no extra records
. tab fillin, mi
_fillin | Freq. Percent Cum.
------------+-----------------------------------
0 | 65,003 100.00 100.00
------------+-----------------------------------
Total | 65,003 100.00
The command works fine on a subset of the same data:
. tab sex, mi
sex | Freq. Percent Cum.
------------+-----------------------------------
1 | 35 49.30 49.30
2 | 36 50.70 100.00
------------+-----------------------------------
Total | 71 100.00
then:
. fillin sex soal
_fillin | Freq. Percent Cum.
------------+-----------------------------------
0 | 71 98.61 98.61
1 | 1 1.39 100.00
------------+-----------------------------------
Total | 72 100.00
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Daniel Dedman
Public Health Information Specialist/Analyst
North West Public Health Observatory
Centre for Public Health
Castle House
North street
Liverpool L3 2AY
t: 0151 231 4552
m: 07812 192578
f: 0151 231 4515
e: [email protected]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
LATEST REPORTS
Health Calendar 2007
Synthesis Report on Population Targeting: Tools for Social Marketing
Deaths of those in contact with drug treatment services in the North West of England for 2003/04 and 2004/05
Effects of the Alcohol Misuse Enforcement Campaigns and the Licensing Act 2003 on Violence
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All reports are available at: www.cph.org.uk & www.nwpho.org.uk
*
* 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/
