topic Warning in data steps in SAS Programming

Warning in data steps

Eugenio211 — Fri, 31 Mar 2023 13:25:45 GMT

Hi,

Hope all is well. Can anyone help out with regards to the warning statement below? thanks a lot.

357        proc summary data = have nway missing;
358        class business_state loan_date;
359        var loan_count;
360        output out = final (drop = _type_ _freq_ loan_date_entered) sum=;
361        run;

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

Re: Warning in data steps

PaigeMiller — Fri, 31 Mar 2023 13:31:30 GMT

The is no such variable, so you can't list in in DROP=

Re: Warning in data steps

maguiremq — Fri, 31 Mar 2023 13:31:58 GMT

LOAN_DATE_ENTERED isn't used here, so it is throwing a warning - you're using LOAN_DATE. You don't need to drop a variable on the output dataset that you're not using in PROC SUMMARY.