Hi Ian,
=20
Thanks for looking into this. But I face the problem, even before I =
execute the code. When I open the code in SAS Editor, I see the warning =
message in the Log window.=20
And I've figured out the problem. At the end of the code, I try to =
download the data and export it to a Excel file. The folder where I want =
to save the file contains "&" (D:\A&B\test.xls), which SAS is not =
accepting. So whenever I open this code, I get the warning because of =
the "&".
=20
Thanks & Regards,
Sas.
-----Original Message-----
From: ***@comcast.net [mailto:***@comcast.net]
Sent: Tuesday, October 04, 2005 11:17 PM
To: SAS(r) Discussion
Cc: Gopalakrishnan, Sasindra (GE Consumer Finance, consultant)
Subject: Re: WARNING: Apparent symbolic reference XXXXXXX not resolved
Sas,
=20
I think you will have to give us more information. Do you mean
that you executed just this code and it produced the warning?
=20
%macro timeago(n);
time_&n=3Dintnx('month',today,-&n);
mon_&n=3Dput(month(time_&n),z2.);
year_&n=3Dsubstr(compress(put(year(time_&n),8.)),3,2);
%if &n=3D1 %then %do;
call symput('perfmon1',compress(mon_&n!!year_&n));
%end;
%mend;
%timeago(1);
=20
When I execute the code, I get expected errors but no unresolved
messages.
=20
I was able to produce the complete log shown below with a one
line program:
=20
%put ok ;
=20
No X was typed in the entire system. Here is the log.
1 The SAS System 13:39 Tuesday, October 4, 2005
NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC,
USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
Licensed to The SAS Learning Edition V2.0, Site
0000514771.
NOTE: This session is executing on the WIN_PRO platform.
NOTE: This version of the SAS System is limited to 1000 input
observations.
NOTE: SAS initialization used:
real time 0.21 seconds
cpu time 0.20 seconds
NOTE: AUTOEXEC processing beginning; file is C:\Documents and
Settings\Administrator\My
Documents\autoexec.sas.
WARNING: Apparent symbolic reference XXXXXXX not resolved.
NOTE: AUTOEXEC processing completed.
1 %put ok ;
ok
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA
27513-2414
NOTE: The SAS System used:
real time 0.23 seconds
cpu time 0.21 seconds
=20
However I did have the following lines in the autoexec.
=20
%let z =3D %sysfunc(repeat(%sysfunc(byte(88)),6)) ;
%let q =3D &&&z ;
=20
You might execute the code that you gave in batch mode with the
system option ECHOAUTO at invocation, and then show us the log=20
and a description of your system.
=20
Ian Whitlock
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Date: Tue, 4 Oct 2005 07:28:19 -0400
Reply-To: "Gopalakrishnan, Sasindra (GE Consumer Finance,
consultant)"
< ***@GECIS.GE.COM>
Sender: "SAS(r) Discussion"=20
From: "Gopalakrishnan, Sasindra (GE Consumer Finance,
consultant)"
< ***@GECIS.GE.COM>
Subject: WARNING: Apparent symbolic reference XXXXXXX not
resolved
Content-Type: text/plain; charset=3D"iso-8859-1"
Hi All,
When I open up a SAS code, I get a warning message that says :
WARNING: Apparent symbolic reference XXXXXXX not resolved.
I couldn't find this string XXXXXXX in my code or in the file
name. Would anyone let me know what could be the reason?
FYI, I've only one macro in my code (which obviously is not
related to the string) and here is the same for your reference,
if it would help-
%macro timeago(n);
time_&n=3Dintnx('month',today,-&n);
mon_&n=3Dput(month(time_&n),z2.);
year_&n=3Dsubstr(compress(put(year(time_&n),8.)),3,2);
%if &n=3D1 %then %do;
call symput('perfmon1',compress(mon_&n!!year_&n));
%end;
%mend;
%timeago(1);
Thanks & Regards,
Sas.
=20