Page 1 of 1

constrains / boundaries

Posted: Thu Jul 12, 2018 8:15 pm
by fmantessof
I am running a model with different scenarios to forecast vacancy rates in a commercial real estate market. Please see the screenshot attached with the model equations.

I want to restrict the occupied space series (occupspc_sp) to not surpass 95% of the total stock series (stock_sp), so that the vacancy rate (vacan_sp) never goes below 5%. The idea is that if the occupspc_sp series surpass 95% of the stock_sp series EViews would keep the occupspc_sp at the maximum level of 95% of stock_sp. Occupspc_sp is calculated in Eq3 as an inline text equation (identity). Stock_sp is calculated in Eq11 and is also an inline text equation.

How can I accomplish this ?

Thanks

Re: constrains / boundaries

Posted: Mon Jul 16, 2018 5:31 pm
by EViews Gareth
Use an @recode to impose the restriction.

Code: Select all

Y=@recode(f(X)>.95*Z,.95*Z,f(X))

Re: constrains / boundaries

Posted: Mon Jul 16, 2018 7:41 pm
by fmantessof
Thanks ! Perfect