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/
