suppressing Error Messages

For questions and discussion related to graphs, reports, and other output, including issues related to presenting or publishing results.
Gilbril
Posts: 78
Joined: Thu Aug 19, 2010 2:00 pm

suppressing Error Messages

Unread post by Gilbril »

Dear Tom, I do have to read in a quite large Excel-Database which is actualized frequently. The name of the series is in the first column, followed by descriptions, an the data starts in column 14.
Rats can read in the Excel file, but produces an enormous amount of error Messages (due to the descriptions in between and the data format which is m1.99). I can not change the structure of the database. Is there any possibility to delete the error messages in the output window? Up to now i do this manually.

Thanks a lot

gilbril
TomDoan
Posts: 7814
Joined: Wed Nov 01, 2006 4:36 pm

Re: suppressing Error Messages

Unread post by TomDoan »

Can't you use the TOP, LEFT, BOTTOM and RIGHT options on DATA to skip around the non-data information?
Gilbril
Posts: 78
Joined: Thu Aug 19, 2010 2:00 pm

Re: suppressing Error Messages

Unread post by Gilbril »

The Problem is that I neeed the first column to name the series. Therefore I don't know how to skip around without omitting the first column.

Thanks

gilbril
TomDoan
Posts: 7814
Joined: Wed Nov 01, 2006 4:36 pm

Re: suppressing Error Messages

Unread post by TomDoan »

It sounds like you need

ORG=ROWS,LEFT=14,NOLABELS

then list the series names on the DATA instruction (in order).
Post Reply