topic Re: Proc reg append no obs and rsq in SAS Procedures

Proc reg append no obs and rsq

rickw — Tue, 28 Sep 2010 15:21:55 GMT

Hi,

I want to add noobs and rsquare to parameter estimates.

I know we could use ODS parameter estimates to create the parameter estimates table. However, I want No of obs used, read and Rsqaure also added to this table .. Is there any option in ODS that does it ?

I am using the following code:

ods listing close;
ods output ParameterEstimates=Parameter_Estimates(drop = model dependent df label);

proc reg data = temp;
model &dep = &indep_vars;
by &group_by;
run;

ods listing;

Thank you.

Re: Proc reg append no obs and rsq

Paige — Tue, 28 Sep 2010 15:37:35 GMT

You would need to output other ODS tables that contain R-square and N

Re: Proc reg append no obs and rsq

rickw — Wed, 29 Sep 2010 06:10:11 GMT

Thank you. ODS did the job 🙂

Re: Proc reg append no obs and rsq

rickw — Fri, 01 Oct 2010 16:48:31 GMT

Hi,

When I am running regression using by group processing, SAS stops working when there are less no. of observations in a group.

Is there any way I could tell sas to continue executing for the remainder of the observations rather than stopping.??

Thanks.

Re: Proc reg append no obs and rsq

Paige — Fri, 01 Oct 2010 17:52:28 GMT

I don't observe this.

Could you provide more details? Or a copy of the log?

What do you mean by "stops working"?
What do you mean by "less no. of observations in a group"?

Re: Proc reg append no obs and rsq

rickw — Fri, 01 Oct 2010 19:21:22 GMT

I get the following error:

ERROR: No valid observations are found.
NOTE: The above message was for the following BY group:
Segment=a1 HR_Class=sec2
ERROR: No valid observations are found.
NOTE: The above message was for the following BY group:
Segment=a1 HR_Class=sec3
ERROR: No valid observations are found.
NOTE: The above message was for the following BY group:
Segment=a3 HR_Class=sec1
NOTE: Interactivity disabled with BY processing.
NOTE: PROCEDURE REG used (Total process time):
real time 3.54 seconds

However, I see that my program produces the files that I need to export even though the error message is there. Are the results outputted correct in this case??

Thanks.

Re: Proc reg append no obs and rsq

Paige — Mon, 04 Oct 2010 12:53:43 GMT

> I see that my program produces the files that I
> need to export even though the error message is
> there. Are the results outputted correct in this
> case??

They are correct in my example.