Hello everyone, I am new to stata and for my dissertation I have panel data that looks like this. essentially, i would like to show how the variables vala and cfa interact by running a rolling regression from 1972-1977 with inva being the independent variable. vala stands for tobin Q and cfa for cash flow to asset ratio. i have a lot of observation i just showed a sample with two firms and with only 1972-74 but it goes up to 1977 for each firm. cusip is the firm id.
32 1972 5.6654 28.327 5.125 0 0 0.00543 12 11 1977 0.0939 0.22845 0.57597 34.362 14.90893 0.72 1 52.25176 12.75835 0.91267 -0.694 2655
32 1973 6.21698 24.86791 1.75 0 0 0.01365 12 11 1977 0.116 0.24793 0.51771 37.75 16.25845 0.64 1 44.97321 9.45681 0.28577 0.06977 2655
32 1974 6.9163 20.74889 2.125 0 0 0 12 11 1977 0.09858 0.25247 0.54761 50.325 15.85547 0.87 1 41.04197 6.54565 0.29713 0.81614 2217
,......
800 1972 27.23356 234.1044 31.75 1.6 0.00448 0.00309 12 27 1983 0.05296 0.10439 0.35488 343.679 573.0935 3.4 1 52.25176 32.04441 0.46512 0.13418 8395.5
800 1973 26.60924 210.3978 38.58333 1.6 0.00465 0.00266 12 27 1983 0.08907 0.1044 0.32166 436.146 664.4736 4.6 1 44.97321 27.15046 0.48828 -0.45961 8409
800 1974 27.43908 199.6016 22 1.66667 0.00424 0.00216 12 27 1983 0.09168 0.10029 0.34268 535.0969 772.0064 5.07 1 41.04197 23.60023 0.24057 0.09865 8442
.......