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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.