The RATS Software Forum

Can RATS write to named sheets in EXCEL format. I know we can read DATA(FORMAT=XLSX,ORG=COLUMNS,SHEET="Current") 2001 2016 year y x1 x2 and I would like to copy to the same file in separate 'Forecast' sheet COPY(FORMAT=XLSX,ORG=COLUMNS,SHEET="Forecast") 2017 2020 year fy If copy ...

I am having trouble getting %strcmp to evaluate to 1 or TRUE The goal was to set up if statements that compare a string to a state code if st .eq. "NJ" did not work as I expected So I tried if %strcmp(_) but it always evaluates to 0 I am most puzzled that the following code produces 0's co...

Why does the following program produce errors ? The problem is with the FX2 proc that produces an error at compute fend= fstart + steps - 1 ## SX15. Trying to Store into Constant or Expression. Called Parameter by Value? PROC fx1 option integer fstart option integer steps 1 local integer fend comput...

Thanks Tom but Rats freezes and aborts when it gets to this line

compute sblocks=%blocksplit(wsigma,||block,neqn-block||)

I get a message box saying "A problem caused the program to stop working correctly. Please close the program"

same problem with using %smodify

I am updating old code (not written by me) that uses SMODIFY as a command on a VAR structure to create a small system out of a large equation system, where some series/equations will be treated as predetermined for a forecasting exercise. I found out that SMODIFY is not in RATs 8.2, and I wonder if ...