count for each id_number satisfying certain conditions

[jkf91]

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

[art297 · Accepted solution]

You need to add another statement after your set statement:

by household_id;