Proc Reg title question

xiaolufan — Sat, 03 Dec 2016 08:29:52 GMT

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;

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

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

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;

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;

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.

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

85 proc reg data=newdata;

86 model residsq=reg1 reg2 reg3 hsngval hsnggrow;

87 run;

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;

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

99 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

111

Re: Proc Reg title question

Cynthia_sas — Sat, 03 Dec 2016 13:45:02 GMT

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_references.htm

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

topic Re: Proc Reg title question in SAS Procedures

Proc Reg title question

Re: Proc Reg title question