07-14-2016 06:50 AM
I am getting a warning in some code:
WARNING: The variable in the DROP, KEEP, or RENAME list has never been referenced
Can any one tell me, what can be the scenario of this warning?
07-14-2016 07:22 AM - edited 07-14-2016 07:24 AM
In your output dataset, you have mentioned variable name that is not present in your input dataset.
One example mentioned below, weight, age2 and height variable not present in input dataset.
data temp ( keep = weight drop=age2 rename = (height=ht));
set sashelp.class(keep = age );
07-14-2016 08:34 AM
Most often, I have seen that hapen when I have a typo in a varaible name.
The second most often time I see it is when I am accessing a replacement data set (e.g. monthly processing) and the underlying input dataset has changed. Excel is a frequent culprit.