Help using Base SAS procedures

Proc Reg title question

Reply
Occasional Contributor
Posts: 8

Proc Reg title question

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
SAS Super FREQ
Posts: 8,744

Re: Proc Reg title question

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

Ask a Question
Discussion stats
  • 1 reply
  • 190 views
  • 2 likes
  • 2 in conversation