BookmarkSubscribeRSS Feed
Karthik22
Calcite | Level 5
Hello All,
I have few sas program, it's log file in .txt format which is located in a folder. I need to read all the log files and find the error messages. Please suggest me the code to do this.
1 REPLY 1
Ksharp
Super User
%let path= D:\test\SASLOG ;    /*the path of LOG file*/


filename x pipe "dir &path.\*.log /s /b";
data check_log;
infile x length=len;
input fvar $varying200. len;

length filename fname $ 200;
infile dummy filevar=fvar filename=fname end=last length=len;
do while(not last);
 input log $varying400. len;
 if upcase(log) in: ('ERROR' 'WARNING') then do;filename=fname;output;end;
end;
run;

proc print noobs;run;

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 557 views
  • 1 like
  • 2 in conversation