topic WARNING: The variable Age_ in the DROP, KEEP, or RENAME list has never been referenced in SAS Programming

WARNING: The variable Age_ in the DROP, KEEP, or RENAME list has never been referenced

MAJEED — Wed, 12 Feb 2020 09:31:05 GMT

#I'm Trying to fill up missing values for variable age with adding new column call age_ which will filled with the condition then i ll drop the column age and rename age_ to age however i got the warning above in subject and missing values still missing

Data DATA bank_Filling_All_Missing ;
SET bank_filling_Income;
Age_ = .;
if(Age<0) and (res = 'U') then Age_ = 47.9;
if(Age >1) and (res = 'U') then Age_ = Age;
if(Age<0) and (res = 'R') then Age_ = 48.16;
if(Age>1) and (res = 'R') then Age_ = Age;
if(Age<0) and (res = 'S') then Age_ = 47.7;
if(Age>1) and (res = 'S') then Age_ = Age;
drop Age_;
rename Age_ =Age;
RUN ;

Re: WARNING: The variable Age_ in the DROP, KEEP, or RENAME list has never been referenced

ed_sas_member — Wed, 12 Feb 2020 09:38:14 GMT

Hi @MAJEED

It seems you have two issues:

Data /*DATA*/ bank_Filling_All_Missing ;
SET bank_filling_Income;
Age_ = .;
if(Age<0) and (res = 'U') then Age_ = 47.9;
if(Age >1) and (res = 'U') then Age_ = Age;
if(Age<0) and (res = 'R') then Age_ = 48.16;
if(Age>1) and (res = 'R') then Age_ = Age;
if(Age<0) and (res = 'S') then Age_ = 47.7;
if(Age>1) and (res = 'S') then Age_ = Age;
drop Age/*_*/;
rename Age_ =Age;
RUN ;

Re: WARNING: The variable Age_ in the DROP, KEEP, or RENAME list has never been referenced

MAJEED — Wed, 12 Feb 2020 09:40:15 GMT

what are the issues

Re: WARNING: The variable Age_ in the DROP, KEEP, or RENAME list has never been referenced

novinosrin — Wed, 12 Feb 2020 09:40:36 GMT

plz try

drop Age;
rename Age_ =Age;

instead of

drop Age_;
rename Age_ =Age;

Re: WARNING: The variable Age_ in the DROP, KEEP, or RENAME list has never been referenced

ed_sas_member — Wed, 12 Feb 2020 09:44:18 GMT

HI @MAJEED

Look at the portion in the code I have put in comments ->

/*DATA*/

/*_*/ -> Age instead of Age_

Re: WARNING: The variable Age_ in the DROP, KEEP, or RENAME list has never been referenced

ballardw — Wed, 12 Feb 2020 16:05:54 GMT

@MAJEED wrote:

what are the issues

When you DROP a variable it is no longer available to RENAME.

Note that statements like DROP are not executable. That means the order of their of appearance in a data step doesn't matter. The variable is Dropped. Period.

Which is why you get the same warning with this code:

152  data junk;
153     Set sashelp.class;
154     rename age=newage;
155     drop age;
156  run;

WARNING: The variable age in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 19 observations read from the data set SASHELP.CLASS.