01-10-2012 01:40 PM
How do I derive vist numbers for unsheduled labs. If an unsheduled lab happens between visit 1 and visit 2 then visit number for that unscheduled visit shoud be 1.1 and if there are 2 unscheduled visits between visit 1 and visit 2, then first unscheduled visit should be 1.1 and second unscheduled visit should be 1.2. and so on.. The following in the sample data. Column VISITNUM should be derived.
Thanks in advance.
|100||hematology||RBC||10 JAN 2011||Screening||-1|
|100||hematology||RBC||10 MAR 2011||Baseline||1|
|100||hematology||RBC||10 APR 2011||Month 1||2|
|100||hematology||RBC||15 MAR 2011||Unscheduled||1.1|
|100||hematology||RBC||01 APR 2011||Unscheduled||1.2|
|100||hematology||RBC||10 MAY 2011||Month 2||3|