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

[Carl Severson <carlseverson@gmail.com>]

Hey Lisa, glad it helped.

I think there is an easier solution than a foreach loop. Will this
accomplish what you want?

     by id2013: gen edcount = _n
     by id2013: gen visit = _n
     reshape wide visitVariable, i(id2013) j(visit)

This should give you a single line per person, with a variable that
has the number of visits per person.

Out of curiosity, what kind of models are you running?

Hope that helps.

p.s. In the rare, rare chance that you are located at the University
of Calgary, I'd be happy to sit down with you in person and help with
you data management issues.

Carl

On Sun, Mar 3, 2013 at 12:30 PM, Lisa Cook <hlthsrvcsphd@gmail.com> wrote:
> 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/
*
*   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/