topic Re: Base SAS Programming in SAS Programming

Base SAS Programming

nketata — Thu, 26 Nov 2015 21:43:25 GMT

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

Re: Base SAS Programming

Reeza — Thu, 26 Nov 2015 21:49:27 GMT

Use a find function to search for the word executive in the string, if found, assign it to a variable. Use Retain to hold the value across rows, until you change it again.

retain executive;
if find(name, 'Executive')>0 then executive=name;

Re: Base SAS Programming

PGStats — Fri, 27 Nov 2015 03:21:12 GMT

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;

Re: Base SAS Programming

nketata — Fri, 27 Nov 2015 20:14:08 GMT

Thanks for your input