BookmarkSubscribeRSS Feed
Princeelvisa
Obsidian | Level 7

Hello Everyone,

I have mutual funds data at the quarterly level. I have funds percentage holdings in stocks. I want to run a cross-sectional regression of these funds' percentage holdings on two or three independent variables, which are at the stock level. Each fund has at least 10 stocks. I want the regression by fund per quarter. How do I output the partial r-squared for one independent variable for each fund per quarter after the cross-sectional regression. one of the independent variables is a dummy variable.

Any help, please?

Thank you

2 REPLIES 2
sbxkoenk
SAS Super FREQ

Hello,

 

I have moved your question to the "Statistical Procedures" board.

I would have moved it to the "Forecasting and Econometrics" board, but you clearly state you want to analyze cross-sectional data (and not time-series cross-sectional data = panel data).

Hence, you are in SAS/STAT space and not in SAS/ETS or SAS Econometrics space.

 

Have a look here :

Partial R2 with PROC GLM
https://communities.sas.com/t5/SAS-Studio/Partial-R2-with-PROC-GLM/td-p/429197

 

BR,

Koen

 
Princeelvisa
Obsidian | Level 7

Princeelvisa_0-1686820362002.png

This is the model i want to run. where i is stock, m denotes fund and t is quarter. So a cross-sectional regression for partial-squared for the first independent variable for each fund per quarter.

Thank you Koen, if you can help me with the mode above, I looked at what you posted and it bit different, I am sure.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1138 views
  • 0 likes
  • 2 in conversation