https://communities.sas.com/t5/New-SAS-User/how-to-do-panel-data-regression-with-fixed-effects-SAS/m-p/618265#M19185 <P>Maybe you should try PROC PANEL, so post your question at Forecast forum, since PROC PANEL is under SAS/ETS</P> Sat, 18 Jan 2020 16:16:05 GMT Ksharp 2020-01-18T16:16:05Z https://communities.sas.com/t5/New-SAS-User/how-to-do-panel-data-regression-with-fixed-effects-SAS/m-p/617860#M19142 <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>the format of my data set is as follows.&nbsp;</P><TABLE><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>industry_code</TD><TD>y</TD><TD>x1</TD><TD>x2</TD><TD>x3</TD></TR><TR><TD>20 Microns Ltd</TD><TD>2011</TD><TD>1</TD><TD>956.5</TD><TD>69.8</TD><TD>610.1</TD><TD>542.7</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2012</TD><TD>1</TD><TD>82.3</TD><TD>5.1</TD><TD>142.8</TD><TD>281.8</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2013</TD><TD>1</TD><TD>-25.3</TD><TD>-38.2</TD><TD>-98.7</TD><TD>123</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2014</TD><TD>1</TD><TD>413.7</TD><TD>26.1</TD><TD>130.4</TD><TD>65.8</TD></TR><TR><TD>7Seas Entertainment Ltd.</TD><TD>2011</TD><TD>2</TD><TD>-121.2</TD><TD>100.9</TD><TD>-96.5</TD><TD>88</TD></TR><TR><TD>7Seas Entertainment Ltd.</TD><TD>2012</TD><TD>2</TD><TD>-20.9</TD><TD>-80.7</TD><TD>18.6</TD><TD>246</TD></TR><TR><TD>7Seas Entertainment Ltd.</TD><TD>2013</TD><TD>2</TD><TD>-20.9</TD><TD>-80.7</TD><TD>18.6</TD><TD>246</TD></TR><TR><TD>7Seas Entertainment Ltd.</TD><TD>2014</TD><TD>2</TD><TD>-2.8</TD><TD>-21.8</TD><TD>-104.8</TD><TD>41.4</TD></TR><TR><TD>7Seas Entertainment Ltd.</TD><TD>2015</TD><TD>2</TD><TD>7871.9</TD><TD>1086.5</TD><TD>5092.9</TD><TD>5177.8</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2011</TD><TD>3</TD><TD>-5687.4</TD><TD>-686</TD><TD>-4771.1</TD><TD>1111.3</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2012</TD><TD>3</TD><TD>678.6</TD><TD>-263.9</TD><TD>-134.7</TD><TD>657.5</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2013</TD><TD>3</TD><TD>3450.1</TD><TD>26.3</TD><TD>1066.3</TD><TD>1654.9</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2014</TD><TD>3</TD><TD>1010.7</TD><TD>-41.6</TD><TD>1379.2</TD><TD>41.8</TD></TR><TR><TD>A B B India Ltd.</TD><TD>2015</TD><TD>3</TD><TD>4309.7</TD><TD>88.4</TD><TD>-2329.2</TD><TD>6173.1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2011</TD><TD>1</TD><TD>4309.7</TD><TD>88.4</TD><TD>-2329.2</TD><TD>6173.1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2012</TD><TD>1</TD><TD>39.2</TD><TD>-636</TD><TD>-20</TD><TD>235.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2013</TD><TD>1</TD><TD>1056.3</TD><TD>32.1</TD><TD>611.9</TD><TD>555.8</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2014</TD><TD>1</TD><TD>887.9</TD><TD>56.9</TD><TD>992.2</TD><TD>3359.1</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2015</TD><TD>1</TD><TD>-174.9</TD><TD>1.2</TD><TD>-519.6</TD><TD>232.9</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2016</TD><TD>1</TD><TD>-828.7</TD><TD>542.1</TD><TD>-1084.5</TD><TD>2738.2</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> Thu, 16 Jan 2020 18:32:02 GMT https://communities.sas.com/t5/New-SAS-User/how-to-do-panel-data-regression-with-fixed-effects-SAS/m-p/617860#M19142 srikanthyadav44 2020-01-16T18:32:02Z https://communities.sas.com/t5/New-SAS-User/how-to-do-panel-data-regression-with-fixed-effects-SAS/m-p/618265#M19185 <P>Maybe you should try PROC PANEL, so post your question at Forecast forum, since PROC PANEL is under SAS/ETS</P> Sat, 18 Jan 2020 16:16:05 GMT https://communities.sas.com/t5/New-SAS-User/how-to-do-panel-data-regression-with-fixed-effects-SAS/m-p/618265#M19185 Ksharp 2020-01-18T16:16:05Z