Solved: Re: how to code for continous enrollment using LAG and RETAIN function - Page 2

manya92 · Posted 05-03-2018 03:38 PM

data want;
  set have  (rename=(dtend=dtend_last));
  by enrolid;
  if first.enrolid then dtstart_beg=dtstart;
  retain dtstart_beg;
  if last.enrolid; 
run;

what do you mean by the line highlighted in red

manya92 · Posted 05-03-2018 03:41 PM

and this does not work the same as sql

mkeintz · Posted 05-04-2018 02:35 PM

No red line is showing up.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Re: how to code for continous enrollment using LAG and RETAIN function

Re: how to code for continous enrollment using LAG and RETAIN function

Re: how to code for continous enrollment using LAG and RETAIN function

SAS Innovate 2025: Call for Content

Click image to register for webinar

Classroom Training Available!