topic finding the first quarterly reporting date after a transaction date in SAS Programming

finding the first quarterly reporting date after a transaction date

Mistletoad — Wed, 09 Jun 2021 19:08:19 GMT

Hi,

A have a dataset with a list of transaction dates for different companies.

	transactiondate month lpermno gvkey fyear
1	04/29/1998	4	42455	005697	1998
2	04/30/1998	4	42455	005697	1998
3	05/05/1998	5	42455	005697	1998
4	05/06/1998	5	42455	005697	1998
5	05/07/1998	5	42455	005697	1998
6	03/01/1999	3	42455	005697	1999

I want to determine the first quarterly reporting date after the transactiondate. I have a separate dataset that shows this information.

gvkey fyearq fqtr(quarter) rdq(quarterly reporting date)
23	001000	1971	3	19711109
24	001000	1971	4	19720406
25	001000	1972	1	19720420
26	001000	1972	2	19720724
27	001000	1972	3	19721017
28	001000	1972	4	19730215

Ideally I want the first quarterly reporting date after the transaction date as a column in the first dataset.

I am thinking that I match on gvkey and fyear=fyearq and someone delete the observations in the second dataset that has a rdq before the transaction date and then retain the first rdq after the transaction date.

Thanks

Re: finding the first quarterly reporting date after a transaction date

PaigeMiller — Wed, 09 Jun 2021 21:17:12 GMT

First quarterly reporting date after a transaction date:

first_quarterly_date_after = intnx('quarter',transaction_date,1,'b');

This assumes transaction_date is an actual SAS date, meaning it is the number of days since 01JAN1960.

Re: finding the first quarterly reporting date after a transaction date

Kurt_Bremser — Thu, 10 Jun 2021 04:38:56 GMT

Given your example data, there will not be any results, as all quarterly reporting dates are more than 20 years before the transactions.