Hi there, I'm a novice sas user. A past colleague wrote some sas code for me to format some data. The code works but gives a warning, does the code need changing to remove the error? WARNING: THE VARIABLE INFO IN THE DROP, KEEP, OR RENAME LIST HAS NEVER BEEN REFERENCED The warning related to this line of code %looping; which is at the end of the whole code. This is the whole code: %macro weeklyrecon(filename,weeknumber); data &filename._FINAL; set &filename.; Start_Date= input(put(&starting_date.,8.),yymmdd8.); file_date=Start_date+(&weeknumber.-1)*7; format file_date ddmmyy10.; File_Document_Number=&weeknumber; abc_cost_ID=substr(F1,95,18); abc=substr(f1,95,10); cost_ID=substr(f1,105,8); analysis_1=substr(f1,113,3); analysis_2=''; analysis_3=''; Amount=substr(f1,116,15)*1; Sign=substr(f1,131,1); if sign="+" then DSValue=Amount/100; else if sign="-" then DSValue=-Amount/100; format DSValue 15.2; Analysis5='Weekly'; Analysis6Date=''; Analysis4=compress(substr(f1,134,3),'!@#',' '); drop f1 info sign amount start_date; run; proc sort data=&filename._FINAL; by descending Analysis4; run; %mend; %macro looping; %do i=1 %to &filenum.; %let prefix=weekly_; %let weekly_n=&prefix.&i.; %put &&weekly_n.; %weeklyrecon(&weekly_n.,&i.); %end; %mend looping; %looping; Many thanks
... View more