topic if first variable by another group in SAS Programming

if first variable by another group

user24 — Tue, 07 Mar 2017 13:58:00 GMT

The table i have as below:

id term course ind

2 2016 ENC10 I

2 2017 ENC10 E

5 2010 MAT12 E

5 2012 MAT12 I

6 2011 STA11 E

6 2013 STA11 I

6 2015 STA11 E

Table should be sot like this:

proc sort data = work.a;

by id course term;run;

I neen only same id and course sort by term; last 'ind' should be 'E', first or second ind should be 'I'

So the table should be like below

id term course ind

2 2016 ENC10 I

2 2017 ENC10 E

6 2011 STA11 E

6 2013 STA11 I

6 2015 STA11 E

Re: if first variable by another group

Kurt_Bremser — Tue, 07 Mar 2017 14:17:18 GMT

You have repeatedly been shown how to post data in a data step, and repeatedly been asked by users to do so.

DO SO NOW.

Re: if first variable by another group

RW9 — Tue, 07 Mar 2017 14:20:23 GMT

Again, post test data in the form of a datastep, I am not here to type in test data. As such the logic would be something like:

data have;
  set your_data;
  by id;
  if (first.id or lag(first.id)) and ind="I" then k1=1;
  if last.id and ind="E" then k2=1;
run;
proc sql;
  create table WANT as
  select * from HAVE where ID in (select distinct ID from HAVE where k1 and k2);
quit;