BookmarkSubscribeRSS Feed
srikanthyadav44
Quartz | Level 8

dear all,

i have to perform panel data regression with industry-fixed effects. 

my sample is having  cross-section of companies and time series of years. moreover, industry classification of each company is also mentioned in the data set. 

 

the format of my data set is as follows. 

company_name

year

industry_code

y

x1

x2

x3

20 Microns Ltd

2011

1

956.5

69.8

610.1

542.7

20 Microns Ltd.

2012

1

82.3

5.1

142.8

281.8

20 Microns Ltd.

2013

1

-25.3

-38.2

-98.7

123

20 Microns Ltd.

2014

1

413.7

26.1

130.4

65.8

7Seas Entertainment Ltd.

2011

2

-121.2

100.9

-96.5

88

7Seas Entertainment Ltd.

2012

2

-20.9

-80.7

18.6

246

7Seas Entertainment Ltd.

2013

2

-20.9

-80.7

18.6

246

7Seas Entertainment Ltd.

2014

2

-2.8

-21.8

-104.8

41.4

7Seas Entertainment Ltd.

2015

2

7871.9

1086.5

5092.9

5177.8

A B B India Ltd.

2011

3

-5687.4

-686

-4771.1

1111.3

A B B India Ltd.

2012

3

678.6

-263.9

-134.7

657.5

A B B India Ltd.

2013

3

3450.1

26.3

1066.3

1654.9

A B B India Ltd.

2014

3

1010.7

-41.6

1379.2

41.8

A B B India Ltd.

2015

3

4309.7

88.4

-2329.2

6173.1

3I Infotech Ltd.

2011

1

4309.7

88.4

-2329.2

6173.1

3I Infotech Ltd.

2012

1

39.2

-636

-20

235.2

3I Infotech Ltd.

2013

1

1056.3

32.1

611.9

555.8

3I Infotech Ltd.

2014

1

887.9

56.9

992.2

3359.1

3I Infotech Ltd.

2015

1

-174.9

1.2

-519.6

232.9

3I Infotech Ltd.

2016

1

-828.7

542.1

-1084.5

2738.2

 

industry fixed effects is to be estimated based on industry code. 

please suggest  SAS code 

thanks in advance