Reading in parts of a SAS log

kalbo — Tue, 16 Mar 2021 20:08:25 GMT

Hi, I have a question.

In my SAS log, I there are many occurrences of the following text which is split over 2 lines for example.

NOTE: The above message was for the following BY group:
Unique Subject Identifier=ABCD-123-4567-ABC0001-027 DAGRPID=DA

This text is "buried" in other varying text, example below:

ERROR: The ID value "XITDISP" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
Unique Subject Identifier=ABCD-123-4567-ABC0001-027 DAGRPID=DA
ERROR: The ID value "XITDISP" occurs twice in the same BY group.
ERROR: The ID value "XITDISP" occurs twice in the same BY group.
ERROR: The ID value "XITDISP" occurs twice in the same BY group.

I want to read in only the 2 lines I mention at the top of my post and store all of those in a data set. There are many occurrences of these 2 lines throughout my log file and the text above and below varies.

Any help would be apreciated.

Thanks.

Re: Reading in parts of a SAS log

Reeza — Tue, 16 Mar 2021 20:15:00 GMT

Why? Perhaps query the data set directly to find those cases instead?

If you're looking for generic log parsers, try searching lexjansen.com for many written examples.

topic Re: Reading in parts of a SAS log in SAS Programming

Reading in parts of a SAS log

Re: Reading in parts of a SAS log