topic Re: if some variables are duplicated in SAS Programming

if some variables are duplicated

lerdem — Thu, 16 Jun 2016 15:08:33 GMT

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

Re: if some variables are duplicated

RW9 — Thu, 16 Jun 2016 15:51:21 GMT

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;

Re: if some variables are duplicated

Ksharp — Fri, 17 Jun 2016 02:17:29 GMT

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;