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;
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;
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;
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?
No problem 🙂 Glad you found your answer.
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
See my answer in your other thread
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.