DATA Step, Macro, Functions and more

Unscheduled visits

Frequent Contributor
Posts: 76

Unscheduled visits

How to find the unscheduled visits?

001     01jan2012      10

001     08jan2012       20

001     20jan2012       30

001     27jan2012       40

001     02jan2012       99

001     03jan2012       99

002     02jan2012      10

002     05jan2012      20

002     03jan2012      99

Super User
Posts: 23,661

Re: Unscheduled visits

What's the definition of an unscheduled visit? 

Please post the data as a data step, see examples from your previous questions as well as what the results should look like. Anything you've tried so far would also be helpful. 


PS. It seems like you post a question, then try to work on it or continue working on it.  I would highly suggest trying to phrase your questions according to the 'How to Ask a Good Question' guidelines. 80% of the time I find the answer myself before I finish that process.

Super User
Posts: 23,661

Re: Unscheduled visits

Thanks for the slightly more descriptive subject line Smiley Wink

Posts: 8,163

Re: Unscheduled visits

I am guessing that you want to identify the dates where doses were missed. If that is so, then one possibility would be:


data test;
  informat date date9.;
  format date date9.;
  input id $ date dose;
001     01jan2012      10
001     08jan2012       20
001     20jan2012       30
001     27jan2012       40
001     02jan2012       99
001     03jan2012       99
002     02jan2012      10
002     05jan2012      20
002     03jan2012      99

data want (drop=date last_date dose rename=(missed_date=date));
  set test;
  format missed_date date9.;
  by id;
  if date-last_date gt 1 then do;
    do missed_date=last_date+1 to date-1;

Art, CEO,

Ask a Question
Discussion stats
  • 3 replies
  • 3 in conversation