Reading Multiple Files
Reading Multiple Files
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?
- Attachments
-
- output.rpf
- (4.13 KiB) Downloaded 1097 times
-
- UK_Final_One.xls
- (93 KiB) Downloaded 1091 times
-
- US_Final_One.xls
- (86.5 KiB) Downloaded 1045 times
-
- US_UK_Experiment.rpf
- (1.16 KiB) Downloaded 1069 times
Re: Reading Multiple Files
Add sheet="Sheet3" option to the second DATA instruction. It looks like you must have deleted sheets 1 and 2.
Re: Reading Multiple Files
I followed your instruction. But it is not working
--------------------------------------------------------------------------
open UK_Final_one.xls
data(for=XLS,org=cols,sheet="sheet3")
--------------------------------------------------------------------------
open UK_Final_one.xls
data(for=XLS,org=cols,sheet="sheet3")
Re: Reading Multiple Files
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.
## 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.