st: RE: generate new variables using the first record of the group (in statalist-digest V4 #5050)

["Allan Reese (Cefas)" <allan.reese@cefas.co.uk>]

>How do I generate a new variable with its value for all observations equals to the first observation or the nth observation of >another variable? [in groups according to the subj]

Stata has a system variable to number cases. If the data are sorted, this can be restarted in each group. Having flagged the nth observation in each group, you can copy it. If there are more than one groups, you then have to split off each value, and maybe someone can think of another way to spread each selected value across all obs - if that is what is wanted.

   sort groupvar /* if not already done */
   by groupvar: gen rowno = _n
   gen chosenval = x if rowno == 1  /* or any other value */
   separate  chosenval, by(groupvar) g(cv)
   egen allcv1 = max(cv1)  /* etc, or might be automated in a loop */ 

Allan

 



*
*   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/