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 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 334 views
  • 0 likes
  • 1 in conversation