Hello everyone; I am calculating the experience of acquirers in mergers and acquisitions by counting the number of mergers each acquirors completed in the last 3 years. Year indicates the year of merger completion, CUSIP is the company ID (each company has a unique cusip ID). An acquiror may announce multiple mergers in a single year. So CUSIP may show up more than once in a single year in the have file. By counting CUSIP ID over the last 3 years should give me the measure of acquiror's experience. Frequency_last3yrs is the measure of acquiror's experience. Say CUSIP 52XC23 completed its first mergers in 1994. So the experience of the acquiror in that year is 1.  The company completed two more mergers in 1996. So the experience measure will count the mergers of the company in the last three years-1994, 1995 and 1996. The experience is 3 because the company has one merger in 1994 and 2 in 1996. Please help me in measuring the variable in SAS. I will appreciate your help.   I think one solution could be that I can calculate the frequency of each unique cusip by year (This will help me to put  the right frequency for more than one completion in the same year), and then calculate the total number of mergers in the last three years and merge the output file with original have file to put the measure of experience with each cusip. But I do not know the right code to do it.   data have; input year CUSIP $; datalines; 1980 00034x 1980 005690 1981 56295A 1994 52XC23 1996 52XC23 1996 52XC23 1996 56295A 1997 56295A 1998 56295A 1998 005690 2001 56295A run;       data want; input year CUSIP $ Frequency_last3yrs; datalines; 1980 00034x 1 1980 005690 1 1981 56295A 1 1994 52XC23 1 1996 52XC23 3 1996 52XC23 3 1996 56295A 1 1997 56295A 2 1998 56295A 3 1998 005690 1 2001 56295A 1 run; ... View more

Hello Everone,   I am trying to count the frequency of each observation for the three consequtive years. The counting should consider the missing years also. I do not want to sum the frequency of three consecutive listed years instead I want the sum the frequency of three consecutive years. The count of the first observation of any id is equal to its own frequency and the count of the second consecutive observation of any id is equal to the sum of the frequency of the first and second consecutive years. Please help me.   input year id frequency; 1980 A 2 1982 A 1 1983 A 1 1986 A 2 1996 B 3 1997 B 2 1998 B 1 2001 B 5   The final output should look like the following:   ... View more

Hi, I have company Id and event period in file 1 and business cycle- peak and trough in the the file 2. I want to create a column in file 1 named Cycle which will take name peak if the event date in file 1 is within the peak date range in file 2; and trough if the event date in file 1 is within the trough date range in file 2. I know I can use if function to do it. But the original size of business cycle has many dates for peak. So it is difficult to put the date specifically in the if function. Could anyone please tell me how I can do the job easily without using if function? Please see the descriptions of the variables in each file before you run any code.   File 2: Peak variable is the beginning of peak season Trough variable is the beginning of trough season So, peak season starts from peak variable and ends at one day before the trough date and trough season starts from trough date and ends at one day before next the peak date.   input peak trough; 02/01/1980 10/01/1986 05/01/1995 12/01/2005 01/01/2007 12/01/2015   File 1: id is company id date is the event date input id date; 1 10/01/1980 1 12/10/1990 1 09/11/2000 1 06/12/2010 2 08/20/1980 2 12/11/1990 2 08/07/2000 3 05/06/1990 3 02/03/2010 5 05/11/1990 5 11/10/2010 I am sorry I could not put both of the files in sas code format as I do not know how to do it for files with date variables.   The output file should look like the following:   ... View more