What was the syntax error? You may have gone past the 365th element of your array if you have a discharge day sometime past 1-October-2001, or thereabouts.
Eric
>Hi! I'm still on v8.
>
>I'm looking at one year of data for which one record corresponds to one
>hospitalization. I created variables day1-day365 to represent all the days
>in that year. Now, I would like those variables to be equal to one during an
>hospitalization. I have the admission day (admitday) and the discharge day
>(disday) and using these, I created two variables begin and end that tell me
>when did that hospitalization started and ended. Then I though that I could
>loop from begin to end and change the day array from 0 to 1. However I'm
>getting a syntax error and I think it comes from the begin and end variables
>in the forvalues loop. Can anyone help me?
>
>sample code:
>
>forvalues i=1(1)365 {
> gen day`i'=0
>}
>
>gen begin=admitday-mdy(10,1,2000)+1
>replace begin=1 if begin<=0
>
>gen end=disday-mdy(10,1,2000)+1
>
>forvalues i=begin(1)end {
> replace day`i'=1
>}
>
>sample data:
>
> +--------------------------------------------------------------+
> | study_id admitday disday begin end day1 day2 |
> |--------------------------------------------------------------|
> 1. | 19 03jan2001 24jan2001 95 116 0 0 |
> 2. | 362 24may2001 29may2001 236 241 0 0 |
> 3. | 396 01jun2001 07jun2001 244 250 0 0 |
> 4. | 436 21mar2001 22mar2001 172 173 0 0 |
> 5. | 438 17jan2001 25jan2001 109 117 0 0 |
> |--------------------------------------------------------------|
> 6. | 517 06mar2001 21mar2001 157 172 0 0 |
> 7. | 517 11sep2001 17sep2001 346 352 0 0 |
> 8. | 590 16sep2001 17sep2001 351 352 0 0 |
> 9. | 879 20dec2000 22dec2000 81 83 0 0 |
> +--------------------------------------------------------------+
--
===================================================
Eric G. Wruck
Econalytics
2535 Sherwood Road
Columbus, OH 43209
ph: 614.231.5034
cell: 614.330.8846
eFax: 614.573.6639
eMail: [email protected]
website: http://www.econalytics.com
====================================================
*
* 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/
