Visit Numbers for Unscheduled Labs

Reply
Contributor
Posts: 27

Visit Numbers for Unscheduled Labs

Hi everyone,

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.

SubjectLBCATLBTESTLBDTCVISITVISITNUM
100hematologyRBC10 JAN 2011Screening-1
100hematologyRBC10 MAR 2011Baseline1
100hematologyRBC10 APR 2011Month 12
100hematologyRBC15 MAR 2011Unscheduled1.1
100hematologyRBC01 APR 2011Unscheduled1.2
100hematologyRBC10 MAY 2011Month 23
Post a Question
Discussion Stats
  • 0 replies
  • 440 views
  • 0 likes
  • 1 in conversation