topic Re: %Looping; warning SAS Grid 8.3 WARNING: THE VARIABLE INFO IN THE DROP, KEEP, OR RENAME LIST in SAS Enterprise Guide

%Looping; warning SAS Grid 8.3 WARNING: THE VARIABLE INFO IN THE DROP, KEEP, OR RENAME LIST

Biffothebear — Fri, 06 Oct 2023 00:32:57 GMT

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

Re: %Looping; warning SAS Grid 8.3 WARNING: THE VARIABLE INFO IN THE DROP, KEEP, OR RENAME LIST

Patrick — Fri, 06 Oct 2023 03:03:14 GMT

It's a WARNING not an ERROR which means it's "ugly" but your code will still fully execute.

You get this warning because in your code you attempt to DROP a variable that doesn't exist. Variable INFO doesn't get created in your data step and it obviously also doesn't pre-exist in your input table &filename.

You could just remove INFO from your drop statement.

Re: %Looping; warning SAS Grid 8.3 WARNING: THE VARIABLE INFO IN THE DROP, KEEP, OR RENAME LIST

Biffothebear — Fri, 06 Oct 2023 03:01:12 GMT

Thanks very much, that worked by removing INFO.

Re: %Looping; warning SAS Grid 8.3 WARNING: THE VARIABLE INFO IN THE DROP, KEEP, OR RENAME LIST

Patrick — Fri, 06 Oct 2023 03:14:49 GMT

@Biffothebear Just fyi: SAS system option DKROCOND allows you to change how SAS behaves if dropping a non existent variable.

I'm of the opinion that one should write code that doesn't get into such a situation but just in case below a code sample how you could suppress the warning.

/* store current setting for option dkrocond in macro variable &sv_dkrocond */
%let sv_dkrocond=%sysfunc(getoption(dkrocond,keyword));
/* set option to nowarning */
options dkrocond=nowarning;

data have;
  set sashelp.class;
  drop VarDoesNotExist;
run;

/* restore dkrocond to previous value */
options &sv_dkrocond;