Re: st: Linking a patient file with an event file

[Lisa Cook <hlthsrvcsphd@gmail.com>]

Thank you, Carl.

The code you suggested worked, but once the reshaping is done, I no
longer have an edcount variable (it turns into edcount1, edcount2,
edcount3, etc.). I thought maybe I could use a macro to replace all
the values of edcount with 1 if nonmissing and 0 if missing, then sum
them to get a new count variable. I thought I would try doing it one
step at a time, since I'm inexperienced with macros.

foreach var of varlist `edcount?' {
  replace `var' = 1 if `var' !=.
}

This results in the error "varlist required". Any ideas?

Thanks!
Lisa
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/