Help using Base SAS procedures

count for each id_number satisfying certain conditions

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

count for each id_number satisfying certain conditions

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


Accepted Solutions
Solution
‎08-15-2011 12:23 PM
PROC Star
Posts: 7,366

Re: count for each id_number satisfying certain conditions

You need to add another statement after your set statement:

by household_id;

View solution in original post


All Replies
Solution
‎08-15-2011 12:23 PM
PROC Star
Posts: 7,366

Re: count for each id_number satisfying certain conditions

You need to add another statement after your set statement:

by household_id;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 112 views
  • 1 like
  • 2 in conversation