03-07-2016 11:27 AM
Is there a SAS code out there that can help me scan errors in a log file with the line number the errors occur?
for ex: check for errors, warnings and tells me what line number is that occuring..
Will appreciate any help!!
03-07-2016 12:19 PM
Well, I think EG or one of the other SAS products has a summary which gives a count for each WARNING, ERROR and NOTE. I have developed a couple of these in both SAS and C#, it is a simple load text file and scan for elements you want to scan. I will not provide you code as that is proprietary, but a couple of pointers.
input buffer $;
set <dataset above>;
if index(buffer,"ERROR") > 0 then...
03-08-2016 02:16 AM
Gives the error description an the line of code:
Proc PrintTo Log="C:\Users\NAME\Desktop\Test_Log.Log" NEW; Run; Proc DO_NOT_EXIST_Print; Run; * create an error; Proc DO_NOT_EXIST_Print; Run; Proc DO_NOT_EXIST_Print; Run; Proc PrintTo; Run; Data LogCheck; Infile "C:\Users\NAME\Desktop\Test_Log.Log" Delimiter='09'x Missover DSD Lrecl=32767; Informat LogLine $200.; Format LogLine $200.; Input Logline $; Length Codeline $10.; Retain CodeLine '.'; CodeLine=IfC(NotDigit(Substr(LogLine,1,1)),CodeLine,Scan(LogLine,1,' ')); If Logline=:"ERROR:" Then Output; Run;