Prev: Bug?
Next: Creating new variables
From: Tom Smith on 3 Mar 2010 14:09
I have a followwing dataset with variables -Problem,subject,
cycle, dose .


Problem subject cycle dose
------ ------- ----- ----
pain 1001 1 30
1001 2 30
1001 3 10
1001 4 20
1002 1 20
pain 1002 2 30
1002 3 20
1002 4 40
pain 1003 1 50
1003 2 20
1003 3 10

I need a dataset as below: if the variable "Problem" has a value
"pain" and the value of variable dose of next record is
less than the value of variable dose from the previous record
( previous record means -in which record the variable
'problem" has a value 'pain"), need all rest of the records
for that pateint.


subject cycle dose
------- ------ ------
1002 3 20
1002 4 40
1003 2 20
1003 3 10

Thanks you so much from bottom of my heart.
 | 
Pages: 1
Prev: Bug?
Next: Creating new variables