creating dummy variable- reference.

[Irfan Ali]

Hello All,

I want to generate an indicator variable lets say X=1 if net income (NI) is negative for last two years.

How can i code this in stata?

Thanks in advance.

p.s. my data is panel data

[Nick Cox]

tsset id year 
gen wanted = (L1.NI < 0 ) & (L2.NI < 0)

[Irfan Ali]

Thank you Nick.