BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Kyungjae
Fluorite | Level 6

used proc spatialreg to analyze spatial econometrics model.

However, error messages kept showing up depending on model or data. "Opimization failed. Interpret the estimates with care" or 

"Optimization cannot improve the function value". In addition, although the message 'Algorithm converged' comes out, standard error, t value, and p value don`t appear. 

I specified quasi-Newton method and I specified maximum number of iterations as 1000.

 

When I use SAR model, this output comes out.

Model Fit Summary    
Dependent Variablet_crime    
Number of Observations116    
Data SetLKJ.D05_F    
Spatial WeightsWORK.SWM    
ModelSAR    
Log Likelihood-1058    
Maximum Absolute Gradient1.85E-06    
Number of Iterations167    
Optimization MethodQuasi-Newton    
AIC2144    
SBC2182    
      
Algorithm converged.     
      
Parameter Estimates
ParameterDFEstimateStandardt ValueApprox
ErrorPr > |t|
Intercept18601.9546.3527521354.05<.0001
pop129.053412.87534310.1<.0001
f_rate1794.7308387.86512.050.0405
ac1-634.92147.059-4.32<.0001
ad1380.3811100.0343.80.0001
old1-480.73110.843-4.34<.0001
female1179.7138108.25881.660.0969
college1-164.40358.18005-2.830.0047
mig1-127.12244.54226-2.850.0043
house_11167.052666.635772.510.0122
atax1315.485481.581253.870.0001
train11368.529841.24491.630.1038
_rho10.0888680.1243550.710.4748
_sigma204888967...

 

However, when I use SAC model and other models, these output come out.

Model Fit Summary    
Dependent Variablet_crime    
Number of Observations116    
Data SetLKJ.D05_F    
Spatial WeightsWORK.SWM    
ModelSAC    
Log Likelihood-1474    
Maximum Absolute Gradient2824    
Number of Iterations363    
Optimization MethodQuasi-Newton    
AIC2977    
SBC3018    
      
ERROR: Optimization failed. Interpret the estimates with care.     
      
Parameter Estimates
ParameterDFEstimateStandardt ValueApprox
ErrorPr > |t|
Intercept07284.729...
pop127.554150.92805329.69<.0001
f_rate1315.0701126.68452.490.0129
ac1-540.13356.69547-9.53<.0001
ad1259.39539.987556.49<.0001
old1-450.05336.2234-12.42<.0001
female148.6660379.869230.610.5423
college1-161.94419.16263-8.45<.0001
mig1-92.431114.38729-6.42<.0001
house_11148.855322.763756.54<.0001
atax1307.137126.5171411.58<.0001
train11597.459270.76545.9<.0001
_rho1-0.64940.117049-5.55<.0001
_lambda00.999642...
_sigma214994410.1289613872796<.0001

 

or 

Model Fit Summary    
Dependent Variablet_crime    
Number of Observations116    
Data SetLKJ.D05_F    
Spatial WeightsWORK.SWM    
ModelSMA    
Log Likelihood-1053    
Maximum Absolute Gradient1223    
Number of Iterations281    
Optimization MethodQuasi-Newton    
AIC2133    
SBC2169    
      
WARNING: Optimization cannot improve the function value.     
      
Parameter Estimates
ParameterDFEstimateStandardt ValueApprox
ErrorPr > |t|
Intercept1-3562.5643.40649-82.07<.0001
pop131.241890.270455115.52<.0001
f_rate01113.872...
ac0-631.177...
ad0459.1431...
old0-435.751...
female1352.02770.973919361.45<.0001
college0-153.23...
mig0-106.113...
house_11193.94061.662491116.66<.0001
atax1339.687413.2221725.69<.0001
train11067.57587.9919212.13<.0001
_lambda01...
_sigma202669892...
Restrict1-194906303... *

 

I wonder how I could solve this optimization problem. Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Rick_SAS
SAS Super FREQ

Hard to say since you have not included your code or data, but the most common reason for non-convergence is that the model do not fit the data. Also common is trying to fit  complex model with a small sample. I notice you only have 116 observations but your model contains 14-15 parameters.

 

I assume "get more data" would be hard, so try choosing a simpler model with fewer parameters.

View solution in original post

1 REPLY 1
Rick_SAS
SAS Super FREQ

Hard to say since you have not included your code or data, but the most common reason for non-convergence is that the model do not fit the data. Also common is trying to fit  complex model with a small sample. I notice you only have 116 observations but your model contains 14-15 parameters.

 

I assume "get more data" would be hard, so try choosing a simpler model with fewer parameters.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 319 views
  • 1 like
  • 2 in conversation