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 

 

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

Discussion stats
  • 0 replies
  • 428 views
  • 0 likes
  • 1 in conversation