topic Re: How to identify log files differences between two log files? in SAS Programming

How to identify log files differences between two log files?

gyambqt — Fri, 17 Feb 2023 23:39:00 GMT

For example I have two log files: A and B

A has

B has

So I want to compare the two files line by line and put the difference in another table such as

tablename=Compare_result

line_no records_from_a records_from_b

1 a c

Re: How to identify log files differences between two log files?

Patrick — Sat, 18 Feb 2023 00:37:09 GMT

SAS logs are unstructured text and will differ between executions starting with the execution date. Any small change in logging options will cause changes to the SAS log and especially on which line log messages appear.

I suggest you take a more targeted approach for what you want to collect and let us know.

Below links should be of interest for you.

Track Performance in SAS with the LOGPARSE Macro

SAS® 9.4 Logging: Configuration and Programming Reference, Second Edition

SCAPROC Procedure

SAS® 9.4 Interface to Application Response Measurement (ARM): Reference

Re: How to identify log files differences between two log files?

Ksharp — Sat, 18 Feb 2023 10:37:23 GMT

Using the third side software, like : WinMerge

Re: How to identify log files differences between two log files?

Ksharp — Sat, 18 Feb 2023 10:37:58 GMT

https://winmerge.org/downloads/

Re: How to identify log files differences between two log files?

Quentin — Sat, 18 Feb 2023 19:11:07 GMT

Looks for any utility that does comparison of text files. Notepad++, UltraEdit, DIFF, I'm a big fan of BeyondCompare.

Re: How to identify log files differences between two log files?

Patrick — Sun, 19 Feb 2023 00:18:05 GMT

@Quentin wrote:
Looks for any utility that does comparison of text files. Notepad++, UltraEdit, DIFF, I'm a big fan of BeyondCompare.

Me too! I'm a long time BeyondCompare user and never seen a "better" utility for text comparison that's so rich in functionality yet so intuitive to use.

Re: How to identify log files differences between two log files?

SASKiwi — Sun, 19 Feb 2023 02:11:00 GMT

For what purpose do you want to compare log files?