BookmarkSubscribeRSS Feed
xiaolufan
Calcite | Level 5

I have a question when I run the code, there is a warning of proc reg - spec, the following is my log file

 

I have marked as pink color, please help me to solve this warning.

 

 

 
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
55
56 filename PSET6 '/home/lettief111/PS6';
57 data housing;
58 infile '/home/lettief111/PS6/housing.raw' dlm=',';
59 input state$ popgrow popden pcturban faminc hsng hsnggrow hsngval rent reg1 reg2 reg3 reg4;
60 run;
 
NOTE: The infile '/home/lettief111/PS6/housing.raw' is:
Filename=/home/lettief111/PS6/housing.raw,
Owner Name=lettief111,Group Name=oda,
Access Permission=-rw-r--r--,
Last Modified=03Dec2016:02:49:12,
File Size (bytes)=3683
 
NOTE: 50 records were read from the infile '/home/lettief111/PS6/housing.raw'.
The minimum record length was 67.
The maximum record length was 77.
NOTE: The data set WORK.HOUSING has 50 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 782.18k
OS Memory 35492.00k
Timestamp 12/03/2016 08:11:02 AM
Step Count 69 Switch Count 54
Page Faults 0
Page Reclaims 339
Page Swaps 0
Voluntary Context Switches 166
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
 
 
61
62 proc means data=housing;
63 var rent;
64 run;
 
NOTE: There were 50 observations read from the data set WORK.HOUSING.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.03 seconds
user cpu time 0.04 seconds
system cpu time 0.01 seconds
memory 8291.40k
OS Memory 41672.00k
Timestamp 12/03/2016 08:11:02 AM
Step Count 70 Switch Count 28
Page Faults 0
Page Reclaims 1653
Page Swaps 0
Voluntary Context Switches 74
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
 
 
65
66 proc reg;
67 model rent=reg1 reg2 reg3 hsngval hsnggrow;
68 test reg1=reg2=reg3=0;
69 output out=newdata r=resid;
70 run;
 
71
 
NOTE: The data set WORK.NEWDATA has 50 observations and 14 variables.
NOTE: PROCEDURE REG used (Total process time):
real time 1.06 seconds
user cpu time 0.42 seconds
system cpu time 0.04 seconds
memory 22732.03k
OS Memory 53184.00k
Timestamp 12/03/2016 08:11:03 AM
Step Count 71 Switch Count 68
Page Faults 0
Page Reclaims 16079
Page Swaps 0
Voluntary Context Switches 1088
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 3688
 
72 proc reg;
 
73 model rent=hsngval hsnggrow;
74 run;
 
75
 
NOTE: PROCEDURE REG used (Total process time):
real time 0.82 seconds
user cpu time 0.36 seconds
system cpu time 0.03 seconds
memory 10904.90k
OS Memory 58080.00k
Timestamp 12/03/2016 08:11:04 AM
Step Count 72 Switch Count 54
Page Faults 0
Page Reclaims 12319
Page Swaps 0
Voluntary Context Switches 999
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 2800
 
76 proc reg;
 
77 model rent=reg1 reg2 reg3 hsngval hsnggrow/ white spec;
78 run;
 
WARNING: The average covariance matrix for the SPEC test has been deemed singular which violates an assumption of the test. Use
caution when interpreting the results of the test.
79
 
NOTE: PROCEDURE REG used (Total process time):
real time 0.90 seconds
user cpu time 0.36 seconds
system cpu time 0.04 seconds
memory 10920.06k
OS Memory 58848.00k
Timestamp 12/03/2016 08:11:05 AM
Step Count 73 Switch Count 62
Page Faults 0
Page Reclaims 12324
Page Swaps 0
Voluntary Context Switches 1070
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 3216
 
80 data newdata;
 
81 set newdata;
82 residsq=resid*resid;
83 run;
 
NOTE: There were 50 observations read from the data set WORK.NEWDATA.
NOTE: The data set WORK.NEWDATA has 50 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1057.84k
OS Memory 51880.00k
Timestamp 12/03/2016 08:11:05 AM
Step Count 74 Switch Count 34
Page Faults 0
Page Reclaims 300
Page Swaps 0
Voluntary Context Switches 89
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 264
 
 
84
85 proc reg data=newdata;
86 model residsq=reg1 reg2 reg3 hsngval hsnggrow;
87 run;
 
88
 
NOTE: PROCEDURE REG used (Total process time):
real time 0.87 seconds
user cpu time 0.38 seconds
system cpu time 0.03 seconds
memory 11129.62k
OS Memory 59360.00k
Timestamp 12/03/2016 08:11:06 AM
Step Count 75 Switch Count 56
Page Faults 0
Page Reclaims 12270
Page Swaps 0
Voluntary Context Switches 1042
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 3344
 
89 proc reg data=housing;
 
90 model hsngval=reg1 reg2 reg3 hsnggrow pcturban;
91 run;
 
92
 
NOTE: PROCEDURE REG used (Total process time):
real time 0.85 seconds
user cpu time 0.34 seconds
system cpu time 0.03 seconds
memory 11112.90k
OS Memory 59360.00k
Timestamp 12/03/2016 08:11:07 AM
Step Count 76 Switch Count 54
Page Faults 0
Page Reclaims 12240
Page Swaps 0
Voluntary Context Switches 1027
Involuntary Context Switches 2
Block Input Operations 0
Block Output Operations 3216
 
93 proc syslin 2sls;
 
94 model rent = hsngval hsnggrow reg1 reg2 reg3;
95 endogenous rent hsngval;
96 instruments reg1 reg2 reg3 pcturban hsnggrow;
97 run;
 
NOTE: 50 observations were read.
50 observations were used in the computations.
NOTE: The graph will be rendered as an image due to the use of a gradient contour.
NOTE: The graph will be rendered as an image due to the use of a surface plot.
NOTE: The graph will be rendered as an image due to the use of a bivariate histogram.
NOTE: The graph will be rendered as an image due to the use of a gradient contour.
NOTE: The graph will be rendered as an image due to the use of a surface plot.
NOTE: The graph will be rendered as an image due to the use of a bivariate histogram.
NOTE: PROCEDURE SYSLIN used (Total process time):
real time 0.52 seconds
user cpu time 0.32 seconds
system cpu time 0.03 seconds
memory 12116.09k
OS Memory 60932.00k
Timestamp 12/03/2016 08:11:07 AM
Step Count 77 Switch Count 64
Page Faults 0
Page Reclaims 10876
Page Swaps 0
Voluntary Context Switches 842
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 1776
 
 
98
99 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
111
1 REPLY 1
Cynthia_sas
SAS Super FREQ

Hi:

 This Tech Support note mentions your error message:

http://support.sas.com/kb/22/900.html and, as part of the explanation, references H. White paper, which is shown on this page: http://support.sas.com/documentation/cdl/en/statug/68162/HTML/default/viewer.htm#statug_reg_referenc...

 

  Those might be helpful in figuring out your data.

This user group paper on using PROC REG might also be a useful paper
http://support.sas.com/resources/papers/proceedings10/270-2010.pdf

 

cynthia

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 1 reply
  • 1539 views
  • 2 likes
  • 2 in conversation