For example I have two log files: A and B
A has
a
b
c
B has
c
b
c
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
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
SAS® 9.4 Interface to Application Response Measurement (ARM): Reference
@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.
For what purpose do you want to compare log files?
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.