Good morning SAS Technical Support, I have two datasets, data1 (original example data) and data2 (what I want it to look like).  The variable I am looking to calculate is average delay.   data 1 CIK fyr rpb rpe disclosure_date delay 12344 12 1/1/2009 12/31/2009 3/15/2011 439 12345 6 1/1/2010 6/30/2011 9/17/2011 79 21367 9 8/1/2011 9/30/2013 12/19/2013 80 31269 7 7/1/2013 8/31/2015 1/13/2016 135 43375 1 2/1/2014 7/31/2015 12/11/2015 133   data 2 CIK fyr rpb rpe disclosure_date delay average delay 12344 12 1/1/2009 12/31/2009 3/15/2011 439 439.00 12345 6 1/1/2010 6/30/2011 9/17/2011 79 261.50 21367 9 8/1/2011 9/30/2013 12/19/2013 80 445.33 31269 7 7/1/2013 8/31/2015 1/13/2016 135 432.00 43375 1 2/1/2014 7/31/2015 12/11/2015 133 223.50   I need to calculate the average number of delays a restatement is delayed from fiscal years.  The fiscal month-end of a company is the fyr variable.  For example, observation 1 has an fyr of 12.  That means 12/31 is the fiscal year-end.  Here's how the delay works that I'm looking for: Observation 1 The restatement period is from 1/1/2009 (rpb) to 12/31/2009 (rpe).  This restatement is all only in one period since 12/31/2009 is the fiscal year-end.  Therefore, the average delay is the delay variable (number of days after 12/31/2009 to 3/15/2011 = 439).  12/31/2009 is NOT included in the calculation.  3/15/2011 is the disclosure date.   Observation 2 The restatement period is from 1/1/2010 (rpb) to 6/30/2011 (rpe).  This restatement is in two periods (1/1/2010 through 6/30/2010 and 7/1/2010 through 6/30/2011).  Therefore, the average delay is the average of the number of days after 6/30/2010 through 9/17/2011 (444 days) and the number of days after 6/30/2011 through 9/17/2011 (79), which is 261.50.   The other observations work the same way.    Delay is calculated as follows: Delay = (Datdif (rpe, disclosure_date, 'act/act'));   That delay calculation is only from the end of the restatement periods to the disclosure date.  I need the average of delay for all periods.   Counting number of periods based on fyr is done with the following code: Periods=(intck(catt('qtr.', mod(fyr,3)+1),rpb,rpe)+1)/4;   That may help you with the fyr idea.   Please let me know if you have any questions.  Thank you so much for your help!   God bless, best regards, and have a fabulous weekend, Jadallah       ... View more

Hello SAS Support Communities, I have a few variables left to calculate for this portion of my dissertation.  One of them is calculating the number of quarters covered between rpb and rpe.  The periods1 dataset is the starting point.  The fyr variable is the month of the end of a fiscal year.  For instance, observation 1 has an fyr of 12.  That means 12/31 is the end of the fiscal year.     In the periods1b dataset, fyr1a is the beginning of the fiscal year.  In observation 1, fyr1a is 1 which means that 1/1 is the beginning of the fiscal year.   Periods2 is the way the dataset should look.  Each quarter counts as 0.25.  Observation 1 covers 3 years (4 quarters per year for 3 years).  Therefore, the periods variable = 3;   Look at observation 2.  Fyr is 7, meaning 7/31 is the end of the fiscal year.  Since restatement period is from 7/1/2013 through 7/31/2014, parts of 5 quarters are covered (7/1/2013 through 7/31/2013, 8/1/2013 through 10/31/2013, 11/1/2013 through 1/31/2013, 2/1/2014 through 4/30/2014, and 5/1/2014 through 7/31/2014).  Therefore, the periods variable = 1.25 (0.25 X 5).     I tried using the intck function as follows: data dissert1.periods1c; set dissert1.periods1b; quarters=intck(qtr,rpb,rpe,'C' ); run;   I received the following error in the log: 3052  quarters=intck('qtr','rpb''d,' rpe'd);                                     ---                                     76 ERROR 76-322: Syntax error, statement will be ignored.   3066  data dissert1.periods1c; 3067  set dissert1.periods1b; 3068  quarters=intck(qtr,rpb,rpe,'C' ); 3069  run;   How should I resolve this?   Thank you so much in advance for your help!   God bless, best regards, and take care, Jadallah ... View more

Hello SAS Support Communities,  I have attached dataset comp16f.  Please send me a code I can use to do the following: 1. Standard deviation of ib1 for three years at a time.  Ib1 is the current year, lag1 is the prior year, and lag2 is two years before.  These are already included for each observation. 2. Rank transform the variable created in step 1 between 0 and 1.   Thank you so much in advance for your help!   God bless, best regards, and take care, Jadallah ... View more