dear exeprts,
I need your help with the following
data new;
SET old;
if first.household_id then large_spending_count = 0;
if total_spent>100 then large_spending_count+1;
run;
basically, I want to count how many purchases with total_spent > 100 dollars were made for each household.
so, i want to make large_spending_count = 0 for each new household. it should increase by 1 each time a purchase (>$100) is made.
somehow, it's not working... (it's my first time using first function but I think I need to use it; if not, let me know as well)
can someone please tell me how this may be done?
many thanks,
c
You need to add another statement after your set statement:
by household_id;
You need to add another statement after your set statement:
by household_id;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.