if some variables are duplicated

[lerdem]

I have a table as below:

  id        term        table

  2          2015      bal

  2          2016      bal

  2          2016      tas

  3          2014      som

  3          2015      som

 4           2015     som

 4           2016     bal

 4           2016      cim

i need if same id and same term change the table name as 'BOTH'  like the table as below

id        term        table

  2          2015      bal

  2          2016      BOTH

  3          2014      som

  3          2015      som

 4           2015     som

 4           2016     BOTH

[RW9]

Hi,

proc transpose data=have out=want prefix=var;
  by id term;
  var table;
run;
data want (drop=name var1 var2);
  set want;
  table=ifc(missing(var2),var1,"BOTH");
run;

[Ksharp]

data have;
input id        term        table $;
cards;
  2          2015      bal
  2          2016      bal
  2          2016      tas
  3          2014      som
  3          2015      som
 4           2015     som
 4           2016     bal
 4           2016      cim
;
run;

data want;
 set have;
 by id term;
 if not (first.term and last.term) then  table='BOTH';
 if first.term;
run;