topic how to do panel data regression with fixed effects SAS? in SAS Forecasting and Econometrics https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/how-to-do-panel-data-regression-with-fixed-effects-SAS/m-p/621375#M3732 <P>dear all,</P><P>i have to perform panel data regression with industry-fixed effects.&nbsp;</P><P>my sample is having&nbsp; cross-section of companies and time series of years. moreover, industry classification of each company is also mentioned in the data set.&nbsp;</P><P>&nbsp;</P><P>the format of my data set is as follows.&nbsp;</P><TABLE><TBODY><TR><TD><P>company_name</P></TD><TD><P>year</P></TD><TD><P>industry_code</P></TD><TD><P>y</P></TD><TD><P>x1</P></TD><TD><P>x2</P></TD><TD><P>x3</P></TD></TR><TR><TD><P>20 Microns Ltd</P></TD><TD><P>2011</P></TD><TD><P>1</P></TD><TD><P>956.5</P></TD><TD><P>69.8</P></TD><TD><P>610.1</P></TD><TD><P>542.7</P></TD></TR><TR><TD><P>20 Microns Ltd.</P></TD><TD><P>2012</P></TD><TD><P>1</P></TD><TD><P>82.3</P></TD><TD><P>5.1</P></TD><TD><P>142.8</P></TD><TD><P>281.8</P></TD></TR><TR><TD><P>20 Microns Ltd.</P></TD><TD><P>2013</P></TD><TD><P>1</P></TD><TD><P>-25.3</P></TD><TD><P>-38.2</P></TD><TD><P>-98.7</P></TD><TD><P>123</P></TD></TR><TR><TD><P>20 Microns Ltd.</P></TD><TD><P>2014</P></TD><TD><P>1</P></TD><TD><P>413.7</P></TD><TD><P>26.1</P></TD><TD><P>130.4</P></TD><TD><P>65.8</P></TD></TR><TR><TD><P>7Seas Entertainment Ltd.</P></TD><TD><P>2011</P></TD><TD><P>2</P></TD><TD><P>-121.2</P></TD><TD><P>100.9</P></TD><TD><P>-96.5</P></TD><TD><P>88</P></TD></TR><TR><TD><P>7Seas Entertainment Ltd.</P></TD><TD><P>2012</P></TD><TD><P>2</P></TD><TD><P>-20.9</P></TD><TD><P>-80.7</P></TD><TD><P>18.6</P></TD><TD><P>246</P></TD></TR><TR><TD><P>7Seas Entertainment Ltd.</P></TD><TD><P>2013</P></TD><TD><P>2</P></TD><TD><P>-20.9</P></TD><TD><P>-80.7</P></TD><TD><P>18.6</P></TD><TD><P>246</P></TD></TR><TR><TD><P>7Seas Entertainment Ltd.</P></TD><TD><P>2014</P></TD><TD><P>2</P></TD><TD><P>-2.8</P></TD><TD><P>-21.8</P></TD><TD><P>-104.8</P></TD><TD><P>41.4</P></TD></TR><TR><TD><P>7Seas Entertainment Ltd.</P></TD><TD><P>2015</P></TD><TD><P>2</P></TD><TD><P>7871.9</P></TD><TD><P>1086.5</P></TD><TD><P>5092.9</P></TD><TD><P>5177.8</P></TD></TR><TR><TD><P>A B B India Ltd.</P></TD><TD><P>2011</P></TD><TD><P>3</P></TD><TD><P>-5687.4</P></TD><TD><P>-686</P></TD><TD><P>-4771.1</P></TD><TD><P>1111.3</P></TD></TR><TR><TD><P>A B B India Ltd.</P></TD><TD><P>2012</P></TD><TD><P>3</P></TD><TD><P>678.6</P></TD><TD><P>-263.9</P></TD><TD><P>-134.7</P></TD><TD><P>657.5</P></TD></TR><TR><TD><P>A B B India Ltd.</P></TD><TD><P>2013</P></TD><TD><P>3</P></TD><TD><P>3450.1</P></TD><TD><P>26.3</P></TD><TD><P>1066.3</P></TD><TD><P>1654.9</P></TD></TR><TR><TD><P>A B B India Ltd.</P></TD><TD><P>2014</P></TD><TD><P>3</P></TD><TD><P>1010.7</P></TD><TD><P>-41.6</P></TD><TD><P>1379.2</P></TD><TD><P>41.8</P></TD></TR><TR><TD><P>A B B India Ltd.</P></TD><TD><P>2015</P></TD><TD><P>3</P></TD><TD><P>4309.7</P></TD><TD><P>88.4</P></TD><TD><P>-2329.2</P></TD><TD><P>6173.1</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2011</P></TD><TD><P>1</P></TD><TD><P>4309.7</P></TD><TD><P>88.4</P></TD><TD><P>-2329.2</P></TD><TD><P>6173.1</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2012</P></TD><TD><P>1</P></TD><TD><P>39.2</P></TD><TD><P>-636</P></TD><TD><P>-20</P></TD><TD><P>235.2</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2013</P></TD><TD><P>1</P></TD><TD><P>1056.3</P></TD><TD><P>32.1</P></TD><TD><P>611.9</P></TD><TD><P>555.8</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2014</P></TD><TD><P>1</P></TD><TD><P>887.9</P></TD><TD><P>56.9</P></TD><TD><P>992.2</P></TD><TD><P>3359.1</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2015</P></TD><TD><P>1</P></TD><TD><P>-174.9</P></TD><TD><P>1.2</P></TD><TD><P>-519.6</P></TD><TD><P>232.9</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2016</P></TD><TD><P>1</P></TD><TD><P>-828.7</P></TD><TD><P>542.1</P></TD><TD><P>-1084.5</P></TD><TD><P>2738.2</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>industry fixed effects is to be estimated based on industry code.&nbsp;</P><P>please suggest&nbsp; SAS code&nbsp;</P><P>thanks in advance&nbsp;</P><P>&nbsp;</P> Fri, 31 Jan 2020 05:39:49 GMT srikanthyadav44 2020-01-31T05:39:49Z how to do panel data regression with fixed effects SAS? https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/how-to-do-panel-data-regression-with-fixed-effects-SAS/m-p/621375#M3732 <P>dear all,</P><P>i have to perform panel data regression with industry-fixed effects.&nbsp;</P><P>my sample is having&nbsp; cross-section of companies and time series of years. moreover, industry classification of each company is also mentioned in the data set.&nbsp;</P><P>&nbsp;</P><P>the format of my data set is as follows.&nbsp;</P><TABLE><TBODY><TR><TD><P>company_name</P></TD><TD><P>year</P></TD><TD><P>industry_code</P></TD><TD><P>y</P></TD><TD><P>x1</P></TD><TD><P>x2</P></TD><TD><P>x3</P></TD></TR><TR><TD><P>20 Microns Ltd</P></TD><TD><P>2011</P></TD><TD><P>1</P></TD><TD><P>956.5</P></TD><TD><P>69.8</P></TD><TD><P>610.1</P></TD><TD><P>542.7</P></TD></TR><TR><TD><P>20 Microns Ltd.</P></TD><TD><P>2012</P></TD><TD><P>1</P></TD><TD><P>82.3</P></TD><TD><P>5.1</P></TD><TD><P>142.8</P></TD><TD><P>281.8</P></TD></TR><TR><TD><P>20 Microns Ltd.</P></TD><TD><P>2013</P></TD><TD><P>1</P></TD><TD><P>-25.3</P></TD><TD><P>-38.2</P></TD><TD><P>-98.7</P></TD><TD><P>123</P></TD></TR><TR><TD><P>20 Microns Ltd.</P></TD><TD><P>2014</P></TD><TD><P>1</P></TD><TD><P>413.7</P></TD><TD><P>26.1</P></TD><TD><P>130.4</P></TD><TD><P>65.8</P></TD></TR><TR><TD><P>7Seas Entertainment Ltd.</P></TD><TD><P>2011</P></TD><TD><P>2</P></TD><TD><P>-121.2</P></TD><TD><P>100.9</P></TD><TD><P>-96.5</P></TD><TD><P>88</P></TD></TR><TR><TD><P>7Seas Entertainment Ltd.</P></TD><TD><P>2012</P></TD><TD><P>2</P></TD><TD><P>-20.9</P></TD><TD><P>-80.7</P></TD><TD><P>18.6</P></TD><TD><P>246</P></TD></TR><TR><TD><P>7Seas Entertainment Ltd.</P></TD><TD><P>2013</P></TD><TD><P>2</P></TD><TD><P>-20.9</P></TD><TD><P>-80.7</P></TD><TD><P>18.6</P></TD><TD><P>246</P></TD></TR><TR><TD><P>7Seas Entertainment Ltd.</P></TD><TD><P>2014</P></TD><TD><P>2</P></TD><TD><P>-2.8</P></TD><TD><P>-21.8</P></TD><TD><P>-104.8</P></TD><TD><P>41.4</P></TD></TR><TR><TD><P>7Seas Entertainment Ltd.</P></TD><TD><P>2015</P></TD><TD><P>2</P></TD><TD><P>7871.9</P></TD><TD><P>1086.5</P></TD><TD><P>5092.9</P></TD><TD><P>5177.8</P></TD></TR><TR><TD><P>A B B India Ltd.</P></TD><TD><P>2011</P></TD><TD><P>3</P></TD><TD><P>-5687.4</P></TD><TD><P>-686</P></TD><TD><P>-4771.1</P></TD><TD><P>1111.3</P></TD></TR><TR><TD><P>A B B India Ltd.</P></TD><TD><P>2012</P></TD><TD><P>3</P></TD><TD><P>678.6</P></TD><TD><P>-263.9</P></TD><TD><P>-134.7</P></TD><TD><P>657.5</P></TD></TR><TR><TD><P>A B B India Ltd.</P></TD><TD><P>2013</P></TD><TD><P>3</P></TD><TD><P>3450.1</P></TD><TD><P>26.3</P></TD><TD><P>1066.3</P></TD><TD><P>1654.9</P></TD></TR><TR><TD><P>A B B India Ltd.</P></TD><TD><P>2014</P></TD><TD><P>3</P></TD><TD><P>1010.7</P></TD><TD><P>-41.6</P></TD><TD><P>1379.2</P></TD><TD><P>41.8</P></TD></TR><TR><TD><P>A B B India Ltd.</P></TD><TD><P>2015</P></TD><TD><P>3</P></TD><TD><P>4309.7</P></TD><TD><P>88.4</P></TD><TD><P>-2329.2</P></TD><TD><P>6173.1</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2011</P></TD><TD><P>1</P></TD><TD><P>4309.7</P></TD><TD><P>88.4</P></TD><TD><P>-2329.2</P></TD><TD><P>6173.1</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2012</P></TD><TD><P>1</P></TD><TD><P>39.2</P></TD><TD><P>-636</P></TD><TD><P>-20</P></TD><TD><P>235.2</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2013</P></TD><TD><P>1</P></TD><TD><P>1056.3</P></TD><TD><P>32.1</P></TD><TD><P>611.9</P></TD><TD><P>555.8</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2014</P></TD><TD><P>1</P></TD><TD><P>887.9</P></TD><TD><P>56.9</P></TD><TD><P>992.2</P></TD><TD><P>3359.1</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2015</P></TD><TD><P>1</P></TD><TD><P>-174.9</P></TD><TD><P>1.2</P></TD><TD><P>-519.6</P></TD><TD><P>232.9</P></TD></TR><TR><TD><P>3I Infotech Ltd.</P></TD><TD><P>2016</P></TD><TD><P>1</P></TD><TD><P>-828.7</P></TD><TD><P>542.1</P></TD><TD><P>-1084.5</P></TD><TD><P>2738.2</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>industry fixed effects is to be estimated based on industry code.&nbsp;</P><P>please suggest&nbsp; SAS code&nbsp;</P><P>thanks in advance&nbsp;</P><P>&nbsp;</P> Fri, 31 Jan 2020 05:39:49 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/how-to-do-panel-data-regression-with-fixed-effects-SAS/m-p/621375#M3732 srikanthyadav44 2020-01-31T05:39:49Z