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
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.