Hi all,
I have a list of teams with the name of their executive listed first :
Executive: Moe
bob
sarah
Executive2 : Albert
Joan
Rima
Mark
Executive3: Wendy
etc.
I added 2 variables to tag the executives and the teams, so the file looks like
Executive: Moe 1 1
bob 0 1
sarah 0 1
Executive2 : Albert 1 2
Joan 0 2
Rima 0 2
Mark 0 2
Executive3: Wendy 1 3
etc.
I need another varibale associating the name of the executive with their team. I cannot do a proc format because the file is very long and changes very frequently.
Executive: Moe 1 1 Executive: Moe
bob 0 1 Executive: Moe
sarah 0 1 Executive: Moe
Executive2 : Albert 1 2 Executive2 : Albert
Joan 0 2 Executive2 : Albert
Rima 0 2 Executive2 : Albert
Mark 0 2 Executive2 : Albert
Executive3: Wendy 1 3 Executive3 : Wendy
Thanks
Since the executive name is always listed first, simply take the first name of each team and store it in a retained variable
data want;
retain;
set have; by team;
length execName $32;
if first.team then execName= name;
run;
Thanks for your input
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.