About AmirSari

AmirSari · ‎09-04-2021

The earliest entry for execid=2 starts with a CEO_Dummy=1 because this executive held a CEO role in companyid=28 in 2009. I want the dummy to become 1 if the role has been 'CEO' in any of the previous companies.

AmirSari · ‎09-04-2021

Thank you for your reply. This does not produce what I am looking for. I want an indicator variable that is one if the executive, i.e. execid, held a CEO position in his/her prior experience and zero otherwise.

AmirSari · ‎09-03-2021

Hi all, I have the following dataset and I am trying to create a dummy variable that takes one for execid that held a CEO position at another firm and zero otherwise. Thank you! data have; input execid companyid role $ date yymmdd8.; format date date9.; cards; 1 21 Chairman 20191128 1 21 CEO 20170214 1 13 CEO 20160530 1 13 CFO 20140622 1 18 Director 20110831 1 18 Director 20091220 1 18 CEO 20070217 1 18 CEO 20060302 1 42 CFO 20050410 1 42 Advisor 20040425 1 36 CFO 20020609 1 36 Member 20021025 1 36 Member 20000612 2 31 Advisor 20190515 2 31 Advisor 20160813 2 29 Chairman 20120522 2 28 Director 20110524 2 28 CEO 20090919 2 26 CFO 20080101 2 26 CFO 20060321 ;run; Here is my desired dataset. execid companyid role date CEO_Dummy 1 21 Chairman 20191128 1 1 21 CEO 20170214 1 1 13 CEO 20160530 1 1 13 CFO 20140622 1 1 18 Director 20110831 0 1 18 Director 20091220 0 1 18 CEO 20070217 0 1 18 CEO 20060302 0 1 42 CFO 20050410 0 1 42 Advisor 20040425 0 1 36 CFO 20020609 0 1 36 Member 20021025 0 1 36 Member 20000612 0 2 31 Advisor 20190515 1 2 31 Advisor 20160813 1 2 29 Chairman 20120522 1 2 28 Director 20110524 1 2 28 CEO 20090919 1 2 26 CFO 20080101 1 2 26 CFO 20070321 1 2 31 Advisor 20060813 1 2 29 Chairman 20050522 1 2 28 Director 20040524 1 2 28 CEO 20030919 0 2 26 CFO 20030101 0 2 26 CFO 20010321 0

AmirSari · ‎06-10-2021

Thank you for your reply. The process is similar to moving average and standard deviation in proc expand. It is a 5-year moving skewness that requires at least three values. the values for id=1 are calculated as follows: id year x skew 1 2000 5 0 = skew(5) 1 2001 6 0 = skew(5,6) 1 2002 . 0 = skew (5,6) because 2002 is missing 1 2003 9 1.29334278 =skew(5,6,9) 1 2004 4.6 1.5163234 =skew(5,6,9,4.6) 1 2005 7 0.43480062 = skew(6,9,4.6,7) 1 2006 3.9 0.51928908 = skew(9,4.6,7,3.9) 1 2007 4 0.97698034 = skew(9,4.6,7,3.9,4)

AmirSari · ‎06-10-2021

Hi All, I am trying to find a way to calculate a moving skewness by group for my sample. The window is 5 years from t-4 to t. I tried to use proc expand but it does not seem to have an option for skewness. Any help is greatly appreciated. here is a sample dataset. id year x 1 2000 5 1 2001 6 1 2002 . 1 2003 9 1 2004 4.6 1 2005 7 1 2006 3.9 1 2007 4 2 2000 6 2 2001 3 2 2002 . 2 2003 2 2 2004 . 2 2005 7 2 2006 6 2 2007 8 here is my desired output: id year x skew 1 2000 5 0 1 2001 6 0 1 2002 . 0 1 2003 9 1.29334278 1 2004 4.6 1.5163234 1 2005 7 0.43480062 1 2006 3.9 0.51928908 1 2007 4 0.97698034 2 2000 6 0 2 2001 3 0 2 2002 . 0 2 2003 2 1.29334278 2 2004 . 1.29334278 2 2005 7 1.45786297 2 2006 6 -1.457863 2 2007 8 -1.4430588 Thank you!

AmirSari · ‎03-11-2021

Thank you!

AmirSari · ‎03-11-2021

Thanks for the clarification. How do I reset var1-var3 in order to get my desired output? Would you please provide the code? I am not an expert in SAS.

AmirSari · ‎03-11-2021

Hi Everyone, I am having trouble figuring out why first.id in the following code is not working. The problem is the value of var3 from id=1 is copied over to id=2. I am not sure why the first.id statement is ignored in this case. If you run the following code, you can see that the value of var3 id=1 is copied to var3 id=2 for the first two observations which are supposed to be zero. Th code was provided by @Andreas_Ids Any help is greatly appreciated! data gwill; input id gwill lag_gwill year; cards; 1 100 . 2000 1 150 100 2001 1 130 150 2002 1 140 130 2003 1 150 140 2004 1 120 150 2005 1 110 120 2006 1 100 110 2007 1 140 100 2008 1 160 140 2009 1 180 160 2010 1 110 180 2011 2 200 . 2003 2 200 200 2004 2 170 200 2005 2 150 170 2006 2 150 150 2007 2 140 150 2008 2 170 140 2009 ; run; data want; set gwill; by id; retain start_year var1-var3; if first.id then do; start_year = year; end; select (year); when (start_year) var1 = gwill / 10; when (start_year + 1) var2 = (gwill - lag_gwill) / 10; when (start_year + 2) var3 = (gwill - lag_gwill) / 10; when (start_year + 10) var1 = 0; when (start_year + 11) var2 = 0; when (start_year + 12) var3 = 0; otherwise; end; drop start_year; run; The results should look like this: id gwill Lag_gwill year var1 var2 var3 1 100 2000 10 1 150 100 2001 10 5 1 130 150 2002 10 5 -2 1 140 130 2003 10 5 -2 1 150 140 2004 10 5 -2 1 120 150 2005 10 5 -2 1 110 120 2006 10 5 -2 1 100 110 2007 10 5 -2 1 140 100 2008 10 5 -2 1 160 140 2009 10 5 -2 1 180 160 2010 0 5 -2 1 110 180 2011 0 0 -2 2 200 2003 20 2 200 200 2004 20 0 2 170 200 2005 20 0 -3 2 150 170 2006 20 0 -3 2 150 150 2007 20 0 -3 2 140 150 2008 20 0 -3 2 170 140 2009 20 0 -3

AmirSari · ‎03-11-2021

Thanks, andreas_Ids for your solution. It does work for my example here. However, when I dropped the last observation for id=1, the value of var3 from id=1 is copied over to id=2. I am not sure why the first.id statement is ignored in this case. If you run the following code, you can see that the value of var3 id=1 is copied to var3 id=2 for the first two observations which are supposed to be zero. data gwill; input id gwill lag_gwill year; cards; 1 100 . 2000 1 150 100 2001 1 130 150 2002 1 140 130 2003 1 150 140 2004 1 120 150 2005 1 110 120 2006 1 100 110 2007 1 140 100 2008 1 160 140 2009 1 180 160 2010 1 110 180 2011 2 200 . 2003 2 200 200 2004 2 130 200 2005 2 150 200 2006 2 150 150 2007 2 140 150 2008 2 170 140 2009 ; run; data want; set gwill; by id; retain start_year var1-var3; if first.id then do; start_year = year; end; select (year); when (start_year) var1 = gwill / 10; when (start_year + 1) var2 = (gwill - lag_gwill) / 10; when (start_year + 2) var3 = (gwill - lag_gwill) / 10; when (start_year + 10) var1 = 0; when (start_year + 11) var2 = 0; when (start_year + 12) var3 = 0; otherwise; end; drop start_year; run; Any ideas why this is happenings? Thanks!

AmirSari · ‎03-11-2021

here is what I have. I want to create var1, var2, and var3 in my original post. data ka.gwill; input id gwill lag_gwill year; cards; 1 100 . 2000 1 150 100 2001 1 130 150 2002 1 140 130 2003 1 150 140 2004 1 120 150 2005 1 110 120 2006 1 100 110 2007 1 140 100 2008 1 160 140 2009 1 180 160 2010 1 110 180 2011 1 150 110 2012 2 200 . 2003 2 200 200 2004 2 180 200 2005 2 150 200 2006 2 150 150 2007 2 140 150 2008 2 170 140 2009 2 190 170 2010 2 215 190 2011 2 230 215 2012 2 165 230 2013 2 182 165 2014 ; run; thanks

AmirSari · ‎03-11-2021

Hi Everyone, I am trying to create a variable by id in which the value of the variable is calculated based on another variable and is repeated 10 times for each id. Here is an example of my dataset and my desired variables, i.e. var1, var2, and var3, as well as the calculations for each one of them. I have also attached the dataset in SAS format. id gwill Lag_gwill year var1 var2 var3 1 100 2000 10 = 100/10 1 150 100 2001 10 = 100/10 5 = (150-100)/10 1 130 150 2002 10 = 100/10 5 = (150-100)/10 -2 = (130-150)/10 1 140 130 2003 10 = 100/10 5 = (150-100)/10 -2 = (130-150)/10 1 150 140 2004 10 = 100/10 5 = (150-100)/10 -2 = (130-150)/10 1 120 150 2005 10 = 100/10 5 = (150-100)/10 -2 = (130-150)/10 1 110 120 2006 10 = 100/10 5 = (150-100)/10 -2 = (130-150)/10 1 100 110 2007 10 = 100/10 5 = (150-100)/10 -2 = (130-150)/10 1 140 100 2008 10 = 100/10 5 = (150-100)/10 -2 = (130-150)/10 1 160 140 2009 10 = 100/10 5 = (150-100)/10 -2 = (130-150)/10 1 180 160 2010 0 5 = (150-100)/10 -2 = (130-150)/10 1 110 180 2011 0 0 -2 = (130-150)/10 1 150 110 2012 0 0 0 2 200 2003 20 = 200/10 2 200 200 2004 20 = 200/10 0 = (200-200)/10 2 180 200 2005 20 = 200/10 0 = (200-200)/10 -2 = (180-200)/10 2 150 200 2006 20 = 200/10 0 = (200-200)/10 -2 = (180-200)/10 2 150 150 2007 20 = 200/10 0 = (200-200)/10 -2 = (180-200)/10 2 140 150 2008 20 = 200/10 0 = (200-200)/10 -2 = (180-200)/10 2 170 140 2009 20 = 200/10 0 = (200-200)/10 -2 = (180-200)/10 2 190 170 2010 20 = 200/10 0 = (200-200)/10 -2 = (180-200)/10 2 215 190 2011 20 = 200/10 0 = (200-200)/10 -2 = (180-200)/10 2 230 215 2012 20 = 200/10 0 = (200-200)/10 -2 = (180-200)/10 2 165 230 2013 0 0 = (200-200)/10 -2 = (180-200)/10 2 182 165 2014 0 0 -2 = (180-200)/10 Thanks very much for your help.

AmirSari · ‎03-09-2021

Thank you! This is exactly what I wanted.

AmirSari · ‎03-09-2021

Hello, I would like to have a value repeated until the next line is zero and if the next line is greater than zero then value be added to the previous value . here is a sample of my dataset and my desired output. My data looks like this id date gwil 1 2014 0 1 2015 0 1 2016 100 1 2017 0 1 2018 0 1 2019 20 1 2020 0 1 2021 0 2 2015 0 2 2016 80 2 2017 0 2 2018 0 2 2019 15 2 2020 0 My desired output will look like this id date gwill gwill1 1 2014 0 0 1 2015 0 0 1 2016 100 100 1 2017 0 100 1 2018 0 100 1 2019 20 120 1 2020 0 120 1 2021 0 120 2 2015 0 0 2 2016 80 80 2 2017 0 80 2 2018 0 80 2 2019 15 95 2 2020 0 95 I used the following code and was able to repeat until the next value is zero but can't figure out how to add the next value for the rest of the obseravations. data want; set have; by id notsorted; retain gwlim; if first.id or gwill > 0 then gwlim = gwill; rename gwlim = gwill1; run; Any help is greatly appreciated!

AmirSari · ‎08-17-2020

Thanks everyone for your help!

AmirSari · ‎08-17-2020

Hi I am trying to delete the first observations by group. Here is a sample of my dataset. ID year 1 1995 1 1995 1 1996 1 1996 1 1997 1 1997 1 1997 2 2000 2 2000 2 2000 2 2000 2 2001 2 2001 2 2001 2 2001 What I want: ID year 1 1996 1 1996 1 1997 1 1997 1 1997 2 2001 2 2001 2 2001 2 2001 Thank you!

Online Status	Offline
Date Last Visited	‎04-05-2023 10:53 PM

Re: creating before and after dates using other dates variables

Re: creating before and after dates using other dates variables

creating before and after dates using other dates variables

Re: how to optimize code in proc sql

Re: how to optimize code in proc sql

how to optimize code in proc sql

Re: loop in proc sql

Re: array function

array function

loop in proc sql

Re: creating before and after dates using other dates variables

Re: how to optimize code in proc sql

Re: how to optimize code in proc sql

Re: loop in proc sql

Re: array function

Re: creating dummy by group through time

Re: creating dummy by group through time

creating dummy by group through time

Re: moving skewness

moving skewness

Re: first.id not working

Re: first.id not working

first.id not working

Re: create a variable by group with repeated value

Re: create a variable by group with repeated value

create a variable by group with repeated value

Re: Repeat a value by group

Repeat a value by group

Re: how to delete the first observations by group

how to delete the first observations by group