Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Find the fiscal year for each obs

From   "Yu Chen, PhD" <>
Subject   st: Find the fiscal year for each obs
Date   Sat, 6 Apr 2013 06:15:54 -0500

Dear Statalist,
I have two files. File A contains the daily stock price for each firm,
and file B contains the beginning and ending dates for a fiscal year
for each firm. See below for an illustration (data are hypothetical):

File A:
Firm   Date                Price
IBM    2009/01/15       xxxx
IBM    2009/01/16       xxxx
3M     2010/07/01       yyyy
3M     2010/07/02       yyyy

File B:
Firm   Fiscal Year      Beg. Date    End. Date
IBM    2009               2009/03/01   2010/02/28
IBM    2010               2010/03/01   2011/02/28
3M     2010               2010/06/01    2011/05/31
3M     2011               2011/06/01     2012/05/31

Now, I want indicate in File A for each observation the fiscal year
the observation belongs to, according to the definition in File B.
Conceptually it seems easy: Just compare the date of the observation
in File A with the beginning and ending dates in File B. However, I
find it difficult to write code. Can you help me?
Thank you very much,

Yu Chen
*   For searches and help try:

© Copyright 1996–2016 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index