Your program has a number of macro variables. Which one is not working?
If it is sqlfile, that would be because at no point in the program do
you assign a value to it, you only declare it.
Office of Accountability
NYC Dept. of Education
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Friday, August 08, 2008 10:04 PM
Subject: Global macro var stops working
This is one of those "it worked until now with no changes" things.
Something -must- have changed but two hours of trying hasn't turned up
The macro var in this isn't taking - it's coming out blank, but I swear
worked before. Only even then I couldn't figure out how it was getting
value into sqlfile.
%let nomore = %sysfunc(attrn(&dsid,NOBS));
%do i = 1 %to &nomore;
create table datalib2.&sqlfile
select * from datalib1.&sqlfile;
Any help that lets me get on with my Friday night would be greatly