topic Re: ERROR: The variable MFR_ID in the DROP, KEEP, or RENAME list has never been in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66956#M19140 Check the log to find the transformation where the error is.<BR /> <BR /> Try right-click on the data and select update metadata<BR /> <BR /> Then check your mappings to see if they match your data (and the 'new' metadata). Mon, 22 Dec 2008 21:50:57 GMT GertNissen 2008-12-22T21:50:57Z ERROR: The variable MFR_ID in the DROP, KEEP, or RENAME list has never been https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66955#M19139 I am Using SAS Data Integration Studio, I am getting this error <BR /> <B>"ERROR: The variable MFR_ID in the DROP, KEEP, or RENAME list has never been referenced"</B><BR /> every time , What is this suppose to mean ? where should i have to go in SAS DI to fix this one.<BR /> <BR /> Thanks<BR /> RAM Mon, 22 Dec 2008 21:06:51 GMT https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66955#M19139 deleted_user 2008-12-22T21:06:51Z Re: ERROR: The variable MFR_ID in the DROP, KEEP, or RENAME list has never been https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66956#M19140 Check the log to find the transformation where the error is.<BR /> <BR /> Try right-click on the data and select update metadata<BR /> <BR /> Then check your mappings to see if they match your data (and the 'new' metadata). Mon, 22 Dec 2008 21:50:57 GMT https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66956#M19140 GertNissen 2008-12-22T21:50:57Z Re: ERROR: The variable MFR_ID in the DROP, KEEP, or RENAME list has never https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66957#M19141 I am getting this error in SCD Type 2 Loader,<BR /> Where Should I right-click on the data and select update metadata ?<BR /> Thanks-RAM Mon, 22 Dec 2008 22:15:54 GMT https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66957#M19141 deleted_user 2008-12-22T22:15:54Z Re: ERROR: The variable MFR_ID in the DROP, KEEP, or RENAME list has never https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66958#M19142 I.e. find your data in the Inventory tab in the Tables folder. Mon, 22 Dec 2008 22:34:13 GMT https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66958#M19142 GertNissen 2008-12-22T22:34:13Z Re: ERROR: The variable MFR_ID in the DROP, KEEP, or RENAME list has never https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66959#M19143 Thank you , Its working.<BR /> RM Tue, 23 Dec 2008 21:39:17 GMT https://communities.sas.com/t5/SAS-Procedures/ERROR-The-variable-MFR-ID-in-the-DROP-KEEP-or-RENAME-list-has/m-p/66959#M19143 deleted_user 2008-12-23T21:39:17Z