how do i get the following output

[Mounika2]

output-

pt     element          Start_date      end_date

101 screening        2017-02-10   2017-02-12
102 randomization 2017-02-12   2017-02-16
103 treatment        2017-02-16   2017-02 -18
104 followup          2017-02-18   2017-02-18

 data raw (rename= (visit= ELEMENT));
input pt visit$9. STDT: is8601da.;
format STDT is8601da.;
datalines;
101 screening        2017-02-10
102 randomization 2017-02-12
103 treatment        2017-02-16
104 followup          2017-02-18
run;

[PeterClemmensen · Accepted solution]

 data raw (rename= (visit= ELEMENT));
input pt visit :$13. STDT: is8601da.;
format STDT is8601da.;
datalines;
101 screening 2017-02-10
102 randomization 2017-02-12
103 treatment 2017-02-16
104 followup 2017-02-18
run;

data want;
   merge raw(rename=STDT=start_date) raw(firstobs=2 rename=STDT=end_date keep=STDT) end=lr;
   if lr then end_date=start_date;
run;

[Mounika2]

What does end= lr mean

[PeterClemmensen]

The end=lr option means that I create a temporary variable lr which is equal to 1 on the last observation of the data set and zero otherwise. I use this variable to set the appropriate end_date on the last observation, which should be the same as start_date as I see it. Does that make sense?

[Mounika2]

Yes.
Thank you 😊

[PeterClemmensen]

No problem 🙂 Glad you found your answer.

[Mounika2]

here it is not displaying screening and followup is shown twice. i want only followup start and end dates to be equal and for the rest end date must be the second value of start date

[PeterClemmensen]

See my answer in your other thread