The RATS Software Forum

Thanks Tom. But, I am having one more challenge. If I include the data read commands within the loop, and then instructions after the data read commands but before the end of the loop, I get the following error message. ## SX11. Identifier URU is Not Recognizable. Incorrect Option Field or Parameter...

Tom, I am interested in looping over an SQL statement, as I want to process 300+ indicators for MSAs. Presently, I am reading from an odbc source, with a command like below: data(format=odbc, $ sql="select date, value as URU from la_msa_all_data where area_text like 'houston%' and measure_text ...

Tom, I am having trouble reading Excel 2007 format files. I am using the following code at the start of the file: end(reset) cal(m) 1977 all 0 2020:1 open data "StateSMAIGDP.xlsx" DATA(FORMAT=XLSX,ORG=COLUMNS,SHEET="RATS") / close data When I use the SAME CODE, but substitute XLS...