good afternoon ,i wonder,what shoul i do when my file in excel can't be opened in the RATS version 7.1
can i get a help how to import my data and test for the VAR model ?
how to load the excel to RATS
how to load the excel to RATS
- Attachments
-
- Copy of log return baru.txt
- this is my data
- (68.49 KiB) Downloaded 1406 times
Re: how to load the excel to RATS
Select Data/Graphics/Data (Other Formats). A window named "Select Data File" will be opened. Specify the type of your file, which should be Text Files (*.*) in your case, and locate it. When you hit "Open", a dialog box titled "Spreadsheet Import/Conversion" should pop-up. You can check if everything is properly organized regarding your data and then set the "Target Dates" if necessary.
Re: how to load the excel to RATS
A couple of things to note:
1) In version 7.1, the relevant menu is just called "Data", rather than "Data/Graphics"
2) As suggested in the previous post, the file you included in your message is a text format file, NOT an Excel file. Assuming this text file is actually what you are trying to read, you can use the "text files" choice in the Wizard as suggested above, or just write the DATA instruction directly using FORMAT=PRN and ORG=COLUMNS options.
3) The file you posted appears to have a blank row after the row of series labels. The impact of that blank row probably varies somewhat with different versions of RATS, but I would suggest removing that blank row.
If you still have trouble, I would recommend emailing us at support@estima.com with a copy of your program and data files, as this is more of a "tech support" type question rather than something that would be of general interest to other forum users.
Regards,
Tom Maycock
1) In version 7.1, the relevant menu is just called "Data", rather than "Data/Graphics"
2) As suggested in the previous post, the file you included in your message is a text format file, NOT an Excel file. Assuming this text file is actually what you are trying to read, you can use the "text files" choice in the Wizard as suggested above, or just write the DATA instruction directly using FORMAT=PRN and ORG=COLUMNS options.
3) The file you posted appears to have a blank row after the row of series labels. The impact of that blank row probably varies somewhat with different versions of RATS, but I would suggest removing that blank row.
If you still have trouble, I would recommend emailing us at support@estima.com with a copy of your program and data files, as this is more of a "tech support" type question rather than something that would be of general interest to other forum users.
Regards,
Tom Maycock