Make multiple observations out of one

[Theresa Schmitt]

Dear all,

I'm quite new to Stata and have Restatement information from Audit Analytics. It contains a Variable per firm that indicates the start of a restatement period and the end of the restatement period. I need to create an indicator variable that is set to 1 if the firm-year observation is subject to a restatement. But since between the start period and end period there are usually multiple years in between, I need to generate firm-year observations for each year in between begin date and end date. Can anyone tell me how I execute that in Stata? I attached a screenshot of the respective data.

Thanks a lot for your help!

[Theresa Schmitt]

Solution found

[Carlo Lazzaro]

Theresa:
it would be highly appreciated if you could share the solution you found, as somebody else could benefit from your effort. Thanks.

[Theresa Schmitt]

I attached the basic approach I used.

[Carlo Lazzaro]

Thanks!

[Nayeem Hasan]

Hi Theresa,

Could you please clarify how the code in your screenshot corresponds to the variable names in your table? I am having difficulty identifying any connections between the code and the variable names. If the code provided is only a subset, could you also share the complete code used to generate the years with the restated financial statements?

Thank you!

[Clyde Schechter]

I think that datestart and dateend in the code correspond to res_begin_date and res_end_date, respectively, in the data example.