BookmarkSubscribeRSS Feed
Chang
Quartz | Level 8

hi,

My name is Chang. I have run a linear regression on the relationship between a single dependent and several predictors. I have saved the output as a html. As shown in this output, this analysis produced missing values from some source variables, such as day_temp_diff in type I SS, type III SS and in the parameter estimate table. Can any one please advice on how to annotate the missing values? My gut feeling is that these variables should be removed from my linear model. But I would like to know why there are missing values there. Any comments will be highly appreciated. My codes as below. There are no error message from them. Tassui

%let suffix1= ED;

proc sort data= ED_wide_b out= ED_wide_c;

     by day_type_cat;

run;

proc glm data= ED_wide_c;

    class day_type_cat;

    model day_EDvolume= day_type_cat day_high_temp day_low_temp day_temp_diff day_mean_temp diff_meanDayTemp diff_meanDayRH day_RH_percen day_RH_diff day_high_RH/ solution;

    ods output ParameterEstimates=    _reg01_dPara_&suffix1.;

    ods output NObs=                _reg02_dNum_&suffix1.;

    ods output FitStatistics=        _reg03_dRsq_&suffix1.;

run;

2 REPLIES 2
ballardw
Super User

Have you run any diagnostics on the data such as Proc freq or univariate for the variables in question?

Also, if day_temp_diff = day_high_temp - day_low_temp then since it is determined by two other variables it likely isn't going to contribute anything to the model.

SteveDenham
Jade | Level 19

hit on why there is no estimate.  If the diff is completely dependent on the other two variables, and all are included in the model, the sweep operator will eliminate the redundant variable and set the estimate to missing.

Steve Denham

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 372 views
  • 8 likes
  • 3 in conversation