[Clyde Schechter]

the regression after removing time. the days#busniss variable is an intersection variable to study days with busniss_policy.

Code:

reghdfe cases_normed i.days#busniss_policy cases_normed_delay_14days cases_normed_delay_14days_growth residential workplaces transit_stations parks grocery_and_pharmacy retail_and_recreation if days<=368 & days>=331&mask!="2077-12-31", absorb(fips ) vce(cluster fips)
and still can not get the margin estimation as it is not estimable for all coefficient.

Can you provide new example data that exhibits this problem. As I've said, in the example I have, I don't reproduce the problem. So I need data that reproduces the problem to figure out what is causing it. Evidently there is still some excess colinearity going on, and we need to figure out what that is. To save space, the data example only needs to contain cases_normed, days, busniss_policy, and fips variables.

[amera amery]

As I do not know which sample i should upload to guarantee it is satisfied my code i uploaded the variables you asked for on this shared drive. it is stata dataset we can open it directly and use the below code. Sorry for that but I really want to figure out the problem to adopt the results in my current research.

ssc install reghdfe
ssc install ftools

reghdfe cases_normed i.days#busniss_policy  if days<=368 & days>=331&mask!="2077-12-31", absorb(fips ) vce(cluster fips)

[Clyde Schechter]

Let's try a different approach. I don't want to download from Google Drive.

Please run the following regressions in your full data and show the complete results:

regress days i.fips i.busniss_policy

regress days i.fips i.busniss_policy if days<=368 & days>=331&mask!="2077-12-31"

[amera amery]

I have attached the results in theses files labeled by the command used in each one. Using second command R-sq=0.

[Clyde Schechter]

The results you have shown are not the actual output from the -regress- commands; they have been laundered through one of the pretty-print programs like -estout- or the like. They do not include all the information I need to see. Please show the actual complete output from the -regress- commands, including the command itself and everything that Stata gives you, including any messages. Do not modify it in any way. There are no unimportant details. And please do not attach the files. I really dislike opening attachments from people I don't know. Copy the results to your clipboard from the Results window or your output log and then paste the results here in the forum between code delimiters so the information aligns properly. (If you don't know how to use code delimiters, read Forum FAQ #12 for instructions.)

I want to help you, but you need to help me do that.

[amera amery]

Thank you. I am Sorry as the output is very large it is 3000 fips for counties. that is why I tried to put them on txt file. I will try yo send them again.

[amera amery]

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  U:\results3.smcl
  log type:  smcl
 opened on:   5 Nov 2021, 15:54:18

. do "C:\Users\aalamer1\AppData\Local\Temp\STD1dbc_000000.tmp"

. regress days i.fips i.busniss_policy

      Source |       SS           df       MS      Number of obs   =   104,618
-------------+----------------------------------   F(181, 104436)  =   1332.46
       Model |  6.1222e+09       181  33824323.3   Prob > F        =    0.0000
    Residual |  2.6511e+09   104,436  25384.8427   R-squared       =    0.6978
-------------+----------------------------------   Adj R-squared   =    0.6973
       Total |  8.7733e+09   104,617  83861.0737   Root MSE        =    159.33

----------------------------------------------------------------------------------
            days | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-----------------+----------------------------------------------------------------
            fips |
           1003  |  -1.45e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1005  |  -1.40e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1007  |  -1.40e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1009  |  -1.48e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1011  |  -1.49e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1013  |  -1.40e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1015  |  -1.41e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1017  |  -1.37e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1019  |  -1.47e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1021  |  -1.43e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1023  |  -1.43e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1025  |  -1.37e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1027  |  -1.46e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1029  |  -1.44e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1031  |  -1.48e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1033  |  -1.43e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1035  |  -1.44e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1037  |  -1.45e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1039  |  -1.45e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1041  |  -1.56e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1043  |  -1.32e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1045  |  -1.42e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1047  |         19    9.37213     2.03   0.043     .6307493    37.36925
           1049  |  -1.44e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1051  |  -1.63e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1053  |  -1.35e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1055  |  -1.49e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1057  |  -1.32e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1059  |  -1.40e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1061  |  -1.42e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1063  |         23    9.37213     2.45   0.014     4.630749    41.36925
           1065  |  -1.37e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1067  |  -1.47e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1069  |  -1.46e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1071  |  -1.18e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1073  |  -139.9876   19.53085    -7.17   0.000    -178.2678   -101.7074
           1075  |  -1.25e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1077  |  -1.44e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1079  |  -1.20e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1081  |  -1.64e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1083  |  -1.33e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1085  |  -1.44e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1087  |  -1.39e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1089  |          9    9.37213     0.96   0.337    -9.369251    27.36925
           1091  |  -1.57e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1093  |  -1.42e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1095  |  -1.46e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1097  |         15    9.37213     1.60   0.109    -3.369251    33.36925
           1099  |  -1.51e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1101  |         27    9.37213     2.88   0.004     8.630749    45.36925
           1103  |          3    9.37213     0.32   0.749    -15.36925    21.36925
           1105  |  -1.56e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1107  |  -1.60e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1109  |  -1.36e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1111  |  -212.8965   19.31606   -11.02   0.000    -250.7558   -175.0373
           1113  |  -1.56e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1115  |  -1.50e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1117  |         76    9.37213     8.11   0.000     57.63075    94.36925
           1119  |  -1.49e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1121  |  -1.27e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1123  |  -1.43e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1125  |         15    9.37213     1.60   0.109    -3.369251    33.36925
           1127  |  -1.40e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1129  |  -1.47e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1131  |  -1.41e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           1133  |  -1.33e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           2013  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2016  |         78    9.37213     8.32   0.000     59.63075    96.36925
           2020  |         80    9.37213     8.54   0.000     61.63075    98.36925
           2050  |        -12    9.37213    -1.28   0.200    -30.36925    6.369251
           2060  |        -16    9.37213    -1.71   0.088    -34.36925    2.369251
           2068  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2070  |         -2    9.37213    -0.21   0.831    -20.36925    16.36925
           2090  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2100  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2110  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           2122  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2130  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2150  |       -126    9.37213   -13.44   0.000    -144.3693   -107.6307
           2164  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2170  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2180  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2185  |        -48    9.37213    -5.12   0.000    -66.36925   -29.63075
           2188  |  -1.39e-13    9.37213    -0.00   1.000    -18.36925    18.36925
           2195  |         86    9.37213     9.18   0.000     67.63075    104.3693
           2220  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2240  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2261  |         84    9.37213     8.96   0.000     65.63075    102.3693
           2282  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           2290  |       -138    9.37213   -14.72   0.000    -156.3693   -119.6307
           4001  |  -125.9876   19.53085    -6.45   0.000    -164.2678    -87.7074
           4003  |         15    9.37213     1.60   0.109    -3.369251    33.36925
           4005  |         26    9.37213     2.77   0.006     7.630749    44.36925
           4007  |         28    9.37213     2.99   0.003     9.630749    46.36925
           4009  |       -134    9.37213   -14.30   0.000    -152.3693   -115.6307
           4011  |         20    9.37213     2.13   0.033     1.630749    38.36925
           4012  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           4013  |         26    9.37213     2.77   0.006     7.630749    44.36925
           4015  |         13    9.37213     1.39   0.165    -5.369251    31.36925
           4017  |   632.5124   19.53085    32.39   0.000     594.2322    670.7926
           4019  |         27    9.37213     2.88   0.004     8.630749    45.36925
           4021  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           4023  |         27    9.37213     2.88   0.004     8.630749    45.36925
           4025  |      848.5    9.37213    90.53   0.000     830.1307    866.8693
           4027  |         28    9.37213     2.99   0.003     9.630749    46.36925
           5001  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5003  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5005  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5007  |         10    9.37213     1.07   0.286    -8.369251    28.36925
           5009  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5011  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5013  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5015  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5017  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5019  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5021  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5023  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5025  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5027  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5029  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5031  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5033  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5035  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5037  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5039  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5041  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5043  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5045  |          9    9.37213     0.96   0.337    -9.369251    27.36925
           5047  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5049  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5051  |          8    9.37213     0.85   0.393    -10.36925    26.36925
           5053  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5055  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5057  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5059  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5061  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5063  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5065  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5067  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5069  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5071  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5073  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5075  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5077  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5079  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5081  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5083  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5085  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5087  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5089  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5091  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5093  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5095  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5097  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5099  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5101  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5103  |          2    9.37213     0.21   0.831    -16.36925    20.36925
           5105  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5107  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5109  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5111  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5113  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5115  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5117  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5119  |         20    9.37213     2.13   0.033     1.630749    38.36925
           5121  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5123  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5125  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5127  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5129  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5131  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5133  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5135  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5137  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5139  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5141  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5143  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5145  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5147  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
           5149  |         -4    9.37213    -0.43   0.670    -22.36925    14.36925
                 |
1.busniss_policy |   223.3289   17.71768    12.60   0.000     188.6024    258.0553
           _cons |      489.5   6.627097    73.86   0.000      476.511     502.489
----------------------------------------------------------------------------------

. 
end of do-file

. log close
      name:  <unnamed>
       log:  U:\results3.smcl
  log type:  smcl
 closed on:   5 Nov 2021, 15:54:59
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[amera amery]

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  U:\results4.smcl
  log type:  smcl
 opened on:   5 Nov 2021, 15:55:10

. do "C:\Users\aalamer1\AppData\Local\Temp\STD1dbc_000000.tmp"

. regress days i.fips i.busniss_policy if days<=368 & days>=331&mask!="2077-12-31"
note: 1.busniss_policy omitted because of collinearity.

      Source |       SS           df       MS      Number of obs   =     6,270
-------------+----------------------------------   F(164, 6105)    =      0.00
       Model |           0       164           0   Prob > F        =    1.0000
    Residual |    753967.5     6,105       123.5   R-squared       =    0.0000
-------------+----------------------------------   Adj R-squared   =   -0.0269
       Total |    753967.5     6,269  120.269182   Root MSE        =    11.113

----------------------------------------------------------------------------------
            days | Coefficient  Std. err.      t    P>|t|     [95% conf. interval]
-----------------+----------------------------------------------------------------
            fips |
           1003  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1005  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1007  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1009  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1011  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1013  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1015  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1017  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1019  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1021  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1023  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1025  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1027  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1029  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1031  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1033  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1035  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1037  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1039  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1041  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1043  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1045  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1047  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1049  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1051  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1053  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1055  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1057  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1059  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1061  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1063  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1065  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1067  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1069  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1071  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1073  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1075  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1077  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1079  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1081  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1083  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1085  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1087  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1089  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1091  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1093  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1095  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1097  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1099  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1101  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1103  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1105  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1107  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1109  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1111  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1113  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1115  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1117  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1119  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1121  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1123  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1125  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1127  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1129  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1131  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           1133  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2016  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2020  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2050  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2060  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2070  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2110  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2150  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2185  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2188  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2195  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2261  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           2290  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4001  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4003  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4005  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4007  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4009  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4011  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4013  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4015  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4019  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4023  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           4027  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5001  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5003  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5005  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5007  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5009  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5011  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5013  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5015  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5017  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5019  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5021  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5023  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5025  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5027  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5029  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5031  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5033  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5035  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5037  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5039  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5041  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5043  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5045  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5047  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5049  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5051  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5053  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5055  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5057  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5059  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5061  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5063  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5065  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5067  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5069  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5071  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5073  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5075  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5077  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5079  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5081  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5083  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5085  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5087  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5089  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5091  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5093  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5095  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5097  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5099  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5101  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5103  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5105  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5107  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5109  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5111  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5113  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5115  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5117  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5119  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5121  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5123  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5125  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5127  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5129  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5131  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5133  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5135  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5137  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5139  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5141  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5143  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5145  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5147  |          0    2.54951     0.00   1.000    -4.997938    4.997938
           5149  |          0    2.54951     0.00   1.000    -4.997938    4.997938
                 |
1.busniss_policy |          0  (omitted)
           _cons |      349.5   1.802776   193.87   0.000     345.9659    353.0341
----------------------------------------------------------------------------------

. 
end of do-file

.

[Clyde Schechter]

Problem identified. Within the sample you are interested in, namely, if days<=368 & days>=331&mask!="2077-12-31", busniss_policy is constant within each fips. That is the cause of the colinearity you are getting.

If busniss_policy is supposed to represent something that is a fips-level variable, then the solution to your problem is to remove the fips effect from the modeling. Then -regress- runs with no colinearity, and -margins- will provide estimates for each days#busniss_policy combination.

However, I question whether busniss_policy is supposed to be a fips-level variable. I question it, because even though I have no idea what busniss_policy actually represents, in the data not restricted to if days<=368 & days>=331&mask!="2077-12-31", busniss_policy shows variation within individual fips.

So either way, I think there is something wrong with the busniss_policy variable: if it is supposed to be a fips-level variable, then it is incorrect outside your sample of interest, and if it is not supposed to be a fips-level variable then it is miscoded in the sample of interest because there it does not vary within fips. Or perhaps it is "normally" variable within fips but something special happens between 361 and 368 days under condition mask != "2077-12-31" that causes it to not vary within fips. You need to figure out what is going on with that variable.

Anyway, the solution to your difficulty is either to remove fips from the modeling if the busniss_policy variable is OK, or to fix the problems with the busniss_policy variable if it's not.

[amera amery]

Thank you very much. Appreciated.