BookmarkSubscribeRSS Feed
Eugenio211
Quartz | Level 8

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.

2 REPLIES 2
PaigeMiller
Diamond | Level 26

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

--
Paige Miller
maguiremq
SAS Super FREQ

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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 720 views
  • 0 likes
  • 3 in conversation