Thank you so much! I really appreciate this,
Best wishes,
May
--- Eva Poen <[email protected]> wrote:
> Here is one way to do it. Note that I start from
> scratch to create the
> ID variable. You can start with -expand-.
>
> *********************
> clear
> set obs 5
> gen id = _n
> expand 5
> sort id
> list
> bysort id: gen age = 55+(_n*5)
> list
> **********************
>
> Eva
>
> 2008/5/29 MAY BAYDOUN <[email protected]>:
> > Hello,
> >
> > I am trying to create a dataset in which I already
> > have the id numbers but I would like to replicate
> them
> > and add another variable age that has exactly the
> same
> > values for all ids. So, the original file is:
> >
> > id
> > 1
> > 2
> > 3
> > 4
> > 5
> >
> > The file I want to create is:
> >
> > id age
> > 1 60
> > 1 65
> > 1 70
> > 1 75
> > 1 80
> > 2 60
> > 2 65
> > 2 70
> > 2 75
> > 2 80
> > ..
> >
> > I was wondering if you can help find the easiest
> way
> > to do that. Thanks a lot!
> >
> > May
> >
> >
> > May Baydoun, PhD in Epidemiology (UNC-Chapel Hill)
> Staff Scientist, National Institute on Aging,
> NIH/IRP, Biomedical Research Center, Baltimore, MD
> >
> >
> >
> > *
> > * 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/
> >
> *
> * 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/
>
May Baydoun, PhD in Epidemiology (UNC-Chapel Hill) Staff Scientist, National Institute on Aging, NIH/IRP, Biomedical Research Center, Baltimore, MD
*
* 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/