I accidentally omitted a couple of lines before -drop _merge- in the example
do-file:
assert _merge > 1
keep if _merge == 3
The first omitted line is the reason for returning to the database in the
first place. (The original codes aren't needed in order to reshape the
labels wide.) It's there just as a check that the database is set up (e.g.,
declarative referential integrity) and the transfers from the database don't
differ greatly from what is expected or intended. It probably would be
impolitic to frequently pull the entirety of very large tables across a
heavily trafficked network in order to use this tactic.
The second line assumes that only those ICPC categories that at least one
medical student actually reported using during the period are of interest.
Joseph Coveney
*
* 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/
