02-18-2017 04:23 AM
Attached is data I'm working with. I want to decompose the tenure variable (the number of years beginning from the year when the ceo took office) into: 1. Early years: an indicator variable that equals 1 for firm-years that correspond to the first 3 years of a ceo's tenure and 1 otherwise 2.Years_3_5: an indicator variable that equals 1 if tenure is between years 3 and 5 years and 0 otherwise and 3. Year_6_and _over: an indicator variable that equals 1 for tenures after 5 years, and 0 otherwise.
02-18-2017 05:30 AM
Why do you want 3 variables if you can create one with 3 values?
There are several ways to do it:
1) if tenur le 3 then flag=1; else
if tenur le 5 then flag=2; else flag=3;
2) select (tenur);
when (1,2,3) flag=1;
when (4, 5) flag=2;
3) creating a format:
proc format lib=work;
1-3 = '1'
4-5 = '2'
6-high = '3'
set have; /* imported xlsx file */
flag=put(tenur,fmt1.); /* using the format method or insert here any other preffered method from above */
02-18-2017 09:58 AM
I would want to observe certain characteristics of a CEO over their tenure. Tenure starts in the fiscal year they take office and increases with each year the CEO stays in office. Eg. if the CEO's tenure was 10 years, I would want to study the decisions that CEO took in their first three years, their decisions between the third and fifth years, and the sixth year and above. In the same vein, if a CEO's tenure is 1 year for instance, then I can only study their decisions for that year only. I don't know if these codes takes my point into consideration.
02-18-2017 10:20 AM
I'm not an analyst but, with many sas procedures you can get results BY KEY.
In your case, the key - as much as I understand - is built of the 3 variables:
Company_ID PERSONID and the calculated FLAG (or any other name you preffer)
while the FLAG represents the groups of the TENURE - as you defined.
For furthere help, if need to choose sas procedure, you will need sas analyst advise.