count for each id_number satisfying certain conditions

jkf91 — Mon, 15 Aug 2011 16:21:26 GMT

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,

Re: count for each id_number satisfying certain conditions

art297 — Mon, 15 Aug 2011 16:23:52 GMT

You need to add another statement after your set statement:

by household_id;