Error message "Column not found in access or evaluation of 'LnRV.SPY Recursive'dt = Open( "::Desktop:assignment10.jmp" );
window = 4321; //recursive window beginning
rp = dt << New Column( "LnRV.SPY Recursive", numeric );
For( i = 0, i <= N Rows( dt ) - window - 1, i++,
dt << clear row states();
If( i,
dt << Select Rows( 1 :: window + i ),
dt << Select Rows( 1 :: window )
);
dt << Invert Row selection();
dt << Exclude(); //exclude rows outside window
fm = dt <<FIT model=""></FIT>
I am using JMP 17 Pro and can not seem to figure out this error.
macOSRe: Error message "Column not found in access or evaluation of 'LnRV.SPY Recursive'In addition to what hogi suggested you could also add a Show(i) inside your for loop to see when it errors out. If you remove your just created column it would most likely be second loop (i = 1). Also log might have some additional information than just that error message.
Re: Error message "Column not found in access or evaluation of 'LnRV.SPY Recursive'Hm, the code seems to work.
Perhaps some of the columns in the Fit Model doesn't exist such that the fit platform doesn't start?
Without a fit platform, new column with a prediction formula. Then
pred = column(dt, ncols(dt));
dt << delete columns( pred );
will delete LnRV.SPY Recursive.
You could try to remove the
invisible(1),
and
fm << close window()
to check the outcome of the fit ...
How many rows does your data table have?
