Skipping rows when loading data

[schokakola]

Dear all,

I'm loading my data from Datastream using several headings describing the time series. For loading the data in RATS, I transformed the data into another excel sheet without all the headings, only with the name of the time series and the time axis. Since this is quite time-consuming, I wonder if it is possible to directly load the data without transformation. I have something in mind that I can tell RATS that it should only load the data within a defined matrix.

I hope it is clear where my question is and thanks in advance for useful comments.

Best regards
Julia

[TomDoan]

Dear all,

I'm loading my data from Datastream using several headings describing the time series. For loading the data in RATS, I transformed the data into another excel sheet without all the headings, only with the name of the time series and the time axis. Since this is quite time-consuming, I wonder if it is possible to directly load the data without transformation. I have something in mind that I can tell RATS that it should only load the data within a defined matrix.

I hope it is clear where my question is and thanks in advance for useful comments.

Best regards
Julia

That sounds like a perfect situation to use the Data Wizard, which will let you determine which parts of the file to exclude.

What you need is the TOP option on DATA; for instance, TOP=4 will consider your data table to start on the 4th row, thus ignoring anything in the first three. If the file labels aren't usable for RATS, you would also skip that row, and use the NOLABELS option---you would then have to supply the labels as part of the DATA instruction.