I want to build a regression model (OLS) with the following:   My data set is at the medical provider level (N=10,000 approx).  I have several providers within each US state, sometimes hundreds. My dependent variables is "hours worked (for various categories of worker) per patient".  This is at the provider level. My independent variables are:  state (I have 52 states), and the minimum wage in each state (state level variable).   I want state to be a fixed effect, since there are many providers in each state.   How do I specify this model --PROC GLM?   Or is there another proc that's more appropriate?    Thanks!        -Dave   ... View more

When I run a proc means in ODS Excel, I get the output, but it's all in one Excel row.  So if the data set has 50 variables, for example, I'll get 50 rows (each with var name, mean, min, max, etc....), but they're all in one Excel row.  Is there a way to insert each one into a separate Excel row?   Thanks! -Dave  ... View more

I've got SAS University Edition, and every time I start it I get a prompt to upgrade the Oracle Virtual Box.  Should I?  Will I have to re-install the SAS component as well? Here's what I'm seeing:   ... View more