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

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Fluorite | Level 6

Fluorite | Level 6

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

Posted 05-03-2018 03:38 PM (620 views) | In reply to mkeintz

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

Fluorite | Level 6

Fluorite | Level 6

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

Posted 05-03-2018 03:41 PM (605 views) | In reply to manya92

and this does not work the same as sql

PROC Star

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

Posted 05-04-2018 02:35 PM (548 views) | In reply to manya92

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

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

Discussion stats

17 replies
‎05-03-2018 01:45 PM
3685 views
0 likes
5 in conversation