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 (662 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 (647 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 (590 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

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

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Discussion stats

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