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 

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

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