Date:         Wed, 14 Mar 2001 15:21:22 -0500
Reply-To:     Vincent Girard <Vincent.Girard@IRDA.QC.CA>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Vincent Girard <Vincent.Girard@IRDA.QC.CA>
Organization: GlobeTrotter
Subject:      solution

I don't think you can do this except by running the macro so that the macro
variables are resolved and then rerunning the resulting code (cf., SAS-L
message from 1998 below).

Matthew Zack
----------------------------------------------------------------------------
---------
Zack, Matthew M.
From: Self, Karsten
Sent: Wednesday, October 14, 1998 8:32 PM
To: SAS-L@UGA.CC.UGA.EDU
Subject: Re: Tracing variables with missing value.
You can do this indirectly by using the new SAS option RESERVEDB1.  In
conjunction with a reserved fileref MPRINT it will direct resolved macro
code to a file which can then be run as plain SAS code:

options reservedb1 mprint;
filename mprint "my file reference";

%macro foo;
    /* stuff */
    %mend foo;

%foo

...*after* your SAS session has terminated, you can take and run the
contents of the file referenced by MPRINT above.  Your line and column
references will then resolve.

The alternative is to use the MPRINT option to resolve your macro statements
and run the offending code as plain text in your SAS session.  You will need
to strip non-statement text from the LOG output.

--
Karsten M. Self (kself@visa.com)
Trilogy Consulting

    What part of "Gestalt" don't you understand?

> ----------
> From:         Xixi W Yin[SMTP:Xixi.W.Yin@aexp.com]
> Sent:         Wednesday, October 14, 1998 5:04 PM
> To:   SAS-L@UGA.CC.UGA.EDU
> Subject:      Tracing variables with missing value.
>
> SAS-Ls:
>         I need to trace down variable which has missing value. SAS log
> prints
> line # and col # for that variable. unfortunately, program is coded using
> macro, so I really can't find which line is given that line number in log.
> Any
> one can help with this. Thanks.
>
> Xixi
>




-----Original Message-----
From: Vincent Girard [mailto:Vincent.Girard@irda.qc.ca]
Sent: Wednesday, March 14, 2001 2:09 PM
To: Zack, Matthew M.
Subject: Re: how to number log lines when executing macro written in IML
?


Thank Matthew, but what I am looking was for a way to number the MPRINT
generated lines to use the line number refered into the error message. Since
the problems are either a 0 value in the col or row of the X [ x,y] matrix
reference or that X col or rows number are smaller that the x or y values,
you must insert a=ncol(X); b=nrow(X);print a b x y;
untill you find the line in question. Tedious....
Vincent