Page 1 of 1
Reading Multiple Files
Posted: Tue Jun 01, 2021 2:36 pm
by msrahman
I am using RATS to read two attached files. It can read the first file but cannot read the second one. I have attached the output. Any advice?
Re: Reading Multiple Files
Posted: Tue Jun 01, 2021 3:13 pm
by TomDoan
Add sheet="Sheet3" option to the second DATA instruction. It looks like you must have deleted sheets 1 and 2.
Re: Reading Multiple Files
Posted: Tue Jun 01, 2021 4:00 pm
by msrahman
I followed your instruction. But it is not working
--------------------------------------------------------------------------
open UK_Final_one.xls
data(for=XLS,org=cols,sheet="sheet3")
Re: Reading Multiple Files
Posted: Tue Jun 01, 2021 7:15 pm
by TomDoan
Aren't you getting a
## IO53. Probable Error with OPEN US_FINAL_ONE.XLS. Is UNIT parameter missing?
message? The syntax on
open US_Final_One.xls
open UK_Final_one.xls
is wrong. You need
open data US_Final_One.xls
open data UK_Final_one.xls
instead.