topic Re: how do i get the following output in SAS Programming

how do i get the following output

Mounika2 — Sun, 04 Aug 2019 12:32:06 GMT

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;

Re: how do i get the following output

PeterClemmensen — Sun, 04 Aug 2019 12:39:02 GMT

 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;

Re: how do i get the following output

Mounika2 — Sun, 04 Aug 2019 12:57:43 GMT

What does end= lr mean

Re: how do i get the following output

PeterClemmensen — Sun, 04 Aug 2019 13:04:25 GMT

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?

Re: how do i get the following output

Mounika2 — Sun, 04 Aug 2019 13:06:43 GMT

Yes.
Thank you 😊

Re: how do i get the following output

PeterClemmensen — Sun, 04 Aug 2019 13:14:21 GMT

No problem 🙂 Glad you found your answer.

Re: how do i get the following output

Mounika2 — Sun, 04 Aug 2019 13:46:01 GMT

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

Re: how do i get the following output

PeterClemmensen — Sun, 04 Aug 2019 13:47:52 GMT

See my answer in your other thread