Finding ERRORs in SASLOG
in [SAS]
|
From: Paige Miller on 18 Mar 2010 14:43 On Mar 18, 1:51 pm, Patrick <patrick.mat...(a)gmx.ch> wrote: > In SAS EG or PC SAS (9.2, not sure for previous) "find" using a > regular expression is possible. This RegEx should to the job: > ^ERROR[: ] > I believe the same expression could also be used under Unix with > "egrep". Unfortunately, I do not understand what it means to use a RegEx expression on the SASLOG. Pasting your ^ERROR[: ] exactly into the Find dialog box (Ctrl-F) in the SASLOG does not find any ERRORs, even though I know they exist. Exactly where do you issue this regular expression? -- Paige Miller paige\dot\miller \at\ kodak\dot\com
From: Patrick on 18 Mar 2010 15:41 Paige Seems that SAS has to resolve some small inconsistencies. The find window in PC SAS 9.2 differs between a code and a log window. In the code window there is an option "Regular expression search" where the RegEx works. Looks to me as if the PC SAS log window is still using the old find version. Interestingly in SAS EG 4.2 the new find window with RegEx option also works for the Log window. Cheers Patrick
From: xlr82sas on 19 Mar 2010 03:42 On Mar 18, 12:41 pm, Patrick <patrick.mat...(a)gmx.ch> wrote: > Paige > > Seems that SAS has to resolve some small inconsistencies. > > The find window in PC SAS 9.2 differs between a code and a log window. > In the code window there is an option "Regular expression search" > where the RegEx works. Looks to me as if the PC SAS log window is > still using the old find version. > > Interestingly in SAS EG 4.2 the new find window with RegEx option also > works for the Log window. > > Cheers > Patrick Hi SAS-Lers, Quite a few ERROR messages do not have the ':', I have a list somewhere. Note TRACEBACK does not have the ':' or the ERROR string. There are other serious ERRORs that have ERROR and not the ':' and I don't think ERROR always begins in column 1. SAS does seem to always capitilaize ERROR, so use lower case ERROR on your put string. User put "ERR" "OR". if you want the scrub to pick up the error. I have a more complete list of what I consider potential issues in the log, however it does have false positive issues. I also have a perl script somewhere, I will look for it see http://homepage.mac.com/magdelina/.Public/utl.html utl_tipweb.txt /* T002550 CHECK LOG */ also around line 17235 Here is a list of strings I look for - you need to lower case the log statements I have built this string over the years and add to it each time I find a issue in my log I want to trap on. I also tried to oder them from most to least serious, howver you should always eyeball your log. "0 observations rewritten, 0 observations added and 0 observations deleted" " 0 lines" " 0 observations" " 0 records" " 0 rows" " 0 obs" "%to value of" "traceback" "not currently in" "abnormally terminated" "access denied" "allowed" "already been defined" "ambiguous" "apparent invocation" "apparent symbolic" "appears as text" "are not allowed" "argument 1" "argument 2" "argument 3" "assumed" "assuming" "at least" "but appears on" "but is not" "but no" "by-group" "cannot be accessed" "cannot be deleted" "cannot be found" "cannot be loaded" "cannot be" "cannot open" "cartesian" "central parameter" "character in one" "clause has been augmented" "clause references" "cli error" "closing" "columns were too wide" "condition in the" "conflicting attributes" "contain no data in common" "contain unequal" "contains 1 variable" "convert" "converted to" "converted" "could not be fit" "could not be found" "could not be loaded" "could not be written" "could not be" "could not" "creates a common" "default estimation" "default style will be used instead" "defined as both" "did not satisfy" "differ" "different data types" "division by zero" "denied" "does not exist" "does not have enough arguments" "does not match" "doesn't appear" "doesn't have" "double-dash" "due to a" "due to errors" "due to looping" "dummy macro" "ellipsoid centered" "end of macro" "end-of-record" "ending execution" "enter run" "error" "errorabend" "errorcheck=strict" "errors noted" "estimated autoregression parameter" "examine fields" "exceeds 8 characters" "exceed" "execution terminated" "execution terminating" "expected" "expecting" "experimental release" "export cancelled" "expression has no" "extraneous information" "extraneous" "failed to converge" "failed to load" "failed to" "fatal" "firstobs option >" "firstobs option" "generic critical" "groups are not created" "hanging" "has 0 observations" "has _type_" "has a null" "has already been defined" "has already been set" "has already been" "has already" "has become more" "has been reduced" "has been transformed" "has been discarded" "has changed" "has different lengths" "has exceeded" "has multiple" "has never been" "has no condition" "has not been dropped" "has not been" "has too few" "have been detected" "ignored" "ignoring" "illegal" "included in the" "incomplete" "incorrect" "input data set is empty" "input distances have been squared" "input data set is already sorted" "input empty" "insufficient" "invalid" "is already on the" "is already sorted" "is also a dataset" "is ambiguous" "is before the starting" "is included" "is invalid" "is less than or equal" "is less than" "is not a valid" "is not allowed" "is not assigned" "is not greater than" "is not in effect" "is not in" "is not on file" "is not recognized" "is not sorted" "is not valid" "is obsolete" "is sequential" "it is used out" "is obsolete" "labels differ" "length of numeric" "limit set by" "list empty" "lost card" "mathematical operations" "mathemat" "may be incomplete" "may be longer" "may not be as expected" "merge statement has more than" "merge statement" "missing close parentheses" "missing equals sign" "missing on every" "missing semicolon" "missing values" "missing" "misspelled" "mixed engine types" "model contains" "more positional" "multiple lengths" "multiple optimal" "multiple vertical" "multiple" "must be character" "must be entered" "must be followed" "must be given" "must be invoked" "must have appeared" "must precede" "no body file" "no body" "no by" "no cards" "no data set" "no data sets qualify" "no data" "no effect" "no expression" "no file" "no formats found" "no keep" "no libraries" "suppress" "no logical" "no longer exists" "no matching" "no non-missing" "no observations" "no output destinations active" "no output produced" "no output" "no rows were selected" "no rows" "no shape" "no variables found" "no variables specified" "no variables" "none of the options" "not a valid" "not acceptable" "not adjusted" "not all" "not allow character" "not be included" "not be performed" "not currently licensed" "not found" "not in a valid" "not in effect" "not licensed" "not on input data set" "not processed" "not recognized" "not replaced because" "not resolved" "not valid for import" "not valid" "not written" "null where" "numeric in one" "obs=0" "observations not" "obsolete" " omitted due to" "occurred on module" "offline" "one or more lines may be longer" "operand was found in" "option value" "outside the axis" "parenthesis for" "previous errors" "proc sql statements are executed immediately" "product not found" "product with which" "partial initialization" "quoted string" "recursion" "recursive" "reference" "references the data set being updated" "refers to the same" "refers to" "repeat" "request ignored" "required operator not found" "requires a numeric" "requires compatible" "right-hand" "sas set option obs=0" "sas went" "scale parameter was held fixed" "shifted" "starting variable" "statement has been deleted" "statement needs" "statement syntax" "statement transforms" "statistics are mean corrected" "statistics requested" "stop" "stopped" "subroutine" "syntax for this" "the chi-square is small" "too long" "too many array subscripts" "too small" "too wide" "trying to use" "unable to initialize" "unable to" "unable" "unbalanced" "unclosed" "undeclared" "undetermined" "uninitialized" "unknown" "unrecognized" "unref" "unresolved" "unsatisfied" "violation" "was disabled" "was stopped" "was misspelled as" "was not created" "was not defined" "was not found" "was not replaced" "went to a new line" "were excluded" "will be assumed" "will be used" "will not be" "will not load" "will stop executing" "within the range" "you can only" "your request" "zero elements"
From: xlr82sas on 19 Mar 2010 13:52
On Mar 19, 12:42 am, xlr82sas <xlr82...(a)aol.com> wrote: > On Mar 18, 12:41 pm, Patrick <patrick.mat...(a)gmx.ch> wrote: > > > Paige > > > Seems that SAS has to resolve some small inconsistencies. > > > The find window in PC SAS 9.2 differs between a code and a log window. > > In the code window there is an option "Regular expression search" > > where the RegEx works. Looks to me as if the PC SAS log window is > > still using the old find version. > > > Interestingly in SAS EG 4.2 the new find window with RegEx option also > > works for the Log window. > > > Cheers > > Patrick > > Hi SAS-Lers, > > Quite a few ERROR messages do not have the ':', I have a list > somewhere. Note TRACEBACK does not have the ':' or the ERROR string. > There are other serious ERRORs that have ERROR and not the ':' and > I don't think ERROR always begins in column 1. > > SAS does seem to always capitilaize ERROR, so use lower case ERROR > on your put string. User put "ERR" "OR". if you want the scrub to pick > up the error. > > I have a more complete list of what I consider potential issues in > the log, however it does have false positive issues. > I also have a perl script somewhere, I will look for it > > seehttp://homepage.mac.com/magdelina/.Public/utl.html > utl_tipweb.txt > /* T002550 CHECK LOG */ > also around line 17235 > > Here is a list of strings I look for - you need to lower case the log > statements > I have built this string over the years and add to it each time I find > a issue in my log I want to trap on. > > I also tried to oder them from most to least serious, howver you > should always eyeball your log. > > "0 observations rewritten, 0 observations added and 0 observations > deleted" > " 0 lines" > " 0 observations" > " 0 records" > " 0 rows" > " 0 obs" > "%to value of" > "traceback" > "not currently in" > "abnormally terminated" > "access denied" > "allowed" > "already been defined" > "ambiguous" > "apparent invocation" > "apparent symbolic" > "appears as text" > "are not allowed" > "argument 1" > "argument 2" > "argument 3" > "assumed" > "assuming" > "at least" > "but appears on" > "but is not" > "but no" > "by-group" > "cannot be accessed" > "cannot be deleted" > "cannot be found" > "cannot be loaded" > "cannot be" > "cannot open" > "cartesian" > "central parameter" > "character in one" > "clause has been augmented" > "clause references" > "cli error" > "closing" > "columns were too wide" > "condition in the" > "conflicting attributes" > "contain no data in common" > "contain unequal" > "contains 1 variable" > "convert" > "converted to" > "converted" > "could not be fit" > "could not be found" > "could not be loaded" > "could not be written" > "could not be" > "could not" > "creates a common" > "default estimation" > "default style will be used instead" > "defined as both" > "did not satisfy" > "differ" > "different data types" > "division by zero" > "denied" > "does not exist" > "does not have enough arguments" > "does not match" > "doesn't appear" > "doesn't have" > "double-dash" > "due to a" > "due to errors" > "due to looping" > "dummy macro" > "ellipsoid centered" > "end of macro" > "end-of-record" > "ending execution" > "enter run" > "error" > "errorabend" > "errorcheck=strict" > "errors noted" > "estimated autoregression parameter" > "examine fields" > "exceeds 8 characters" > "exceed" > "execution terminated" > "execution terminating" > "expected" > "expecting" > "experimental release" > "export cancelled" > "expression has no" > "extraneous information" > "extraneous" > "failed to converge" > "failed to load" > "failed to" > "fatal" > "firstobs option >" > "firstobs option" > "generic critical" > "groups are not created" > "hanging" > "has 0 observations" > "has _type_" > "has a null" > "has already been defined" > "has already been set" > "has already been" > "has already" > "has become more" > "has been reduced" > "has been transformed" > "has been discarded" > "has changed" > "has different lengths" > "has exceeded" > "has multiple" > "has never been" > "has no condition" > "has not been dropped" > "has not been" > "has too few" > "have been detected" > "ignored" > "ignoring" > "illegal" > "included in the" > "incomplete" > "incorrect" > "input data set is empty" > "input distances have been squared" > "input data set is already sorted" > "input empty" > "insufficient" > "invalid" > "is already on the" > "is already sorted" > "is also a dataset" > "is ambiguous" > "is before the starting" > "is included" > "is invalid" > "is less than or equal" > "is less than" > "is not a valid" > "is not allowed" > "is not assigned" > "is not greater than" > "is not in effect" > "is not in" > "is not on file" > "is not recognized" > "is not sorted" > "is not valid" > "is obsolete" > "is sequential" > "it is used out" > "is obsolete" > "labels differ" > "length of numeric" > "limit set by" > "list empty" > "lost card" > "mathematical operations" > "mathemat" > "may be incomplete" > "may be longer" > "may not be as expected" > "merge statement has more than" > "merge statement" > "missing close parentheses" > "missing equals sign" > "missing on every" > "missing semicolon" > "missing values" > "missing" > "misspelled" > "mixed engine types" > "model contains" > "more positional" > "multiple lengths" > "multiple optimal" > "multiple vertical" > "multiple" > "must be character" > "must be entered" > "must be followed" > "must be given" > "must be invoked" > "must have appeared" > "must precede" > "no body file" > "no body" > "no by" > "no cards" > "no data set" > "no data sets qualify" > "no data" > "no effect" > "no expression" > "no file" > "no formats found" > "no keep" > "no libraries" > "suppress" > "no logical" > "no longer exists" > "no matching" > "no non-missing" > "no observations" > "no output destinations active" > "no output produced" > "no output" > "no rows were selected" > "no rows" > "no shape" > "no variables found" > "no variables specified" > "no variables" > "none of the options" > "not a valid" > "not acceptable" > "not adjusted" > "not all" > "not allow character" > "not be included" > "not be performed" > "not currently licensed" > "not found" > "not in a valid" > "not in effect" > "not licensed" > "not on input data set" > "not processed" > "not recognized" > "not replaced because" > "not resolved" > "not valid for import" > "not valid" > "not written" > "null where" > "numeric in one" > "obs=0" > "observations not" > "obsolete" > " omitted due to" > "occurred on module" > "offline" > "one or more lines may be longer" > "operand was found in" > "option value" > "outside the axis" > "parenthesis for" > "previous errors" > "proc sql statements are executed immediately" > "product not found" > "product with which" > "partial initialization" > "quoted string" > "recursion" > "recursive" > "reference" > "references the data set being updated" > "refers to the same" > "refers to" > "repeat" > "request ignored" > "required operator not found" > "requires a numeric" > "requires compatible" > "right-hand" > "sas set option obs=0" > "sas went" > "scale parameter was held fixed" > "shifted" > "starting variable" > "statement has been deleted" > "statement needs" > "statement syntax" > "statement transforms" > "statistics are mean corrected" > "statistics requested" > "stop" > "stopped" > "subroutine" > "syntax for this" > "the chi-square is small" > "too long" > "too many array subscripts" > "too small" > "too wide" > "trying to use" > "unable to initialize" > "unable to" > "unable" > "unbalanced" > "unclosed" > "undeclared" > "undetermined" > "uninitialized" > "unknown" > "unrecognized" > "unref" > "unresolved" > "unsatisfied" > "violation" > "was disabled" > "was stopped" > "was misspelled as" > "was not created" > "was not defined" > "was not found" > "was not replaced" > "went to a new line" > "were excluded" > "will be assumed" > "will be used" > "will not be" > "will not load" > "will stop executing" > "within the range" > "you can only" > "your request" > "zero elements" Hi SAS-Lers, As a side note, If I hit CTL T, a logscrub on the log scrub of the log window will be palced in in note h,h CTL T log;file "./&pgm..log";note zx;notesubmit '%utl_logcurchk(./ &pgm..log);'; Also 'ctl h' changes focus to the log scrub output CTL H note h.h Not sure this works in the enhanced editor and it certainly does not work in the super enhanced EG, Enterprise Guide. |