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.
The is no such variable, so you can't list in in DROP=
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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.