About zma4

zma4 · ‎10-03-2018

Thank you, is there a way to deliver the output inside the data step (inside the loop), instead of creating and merging the datasets at the end? I am thinking if in case that there are more threshold levels (for example. starting at 800 and 50), there will be more levels that have count = 0, creating data and then merge them is not really efficient. Thank you.

zma4 · ‎10-03-2018

Thank you for your reply. I found out that the output table does not include the count/frequency for Threshold_Amount = 500 /Threshold_Days = 20 for Segment A and Threshold_Amount = 500/Threshold_Days = 30 for Segment B. The actual counts/frequency for these Thresholds are 0s. Is there a way to modify the code to include those observations even the count/frequency is 0? Thank you

zma4 · ‎10-02-2018

Dear Community: I have a table below (T1) and based on the table, I want to count the number of observations for each segment that meets the threshold condition: if Amount >= Threshold_Amount and Days >= Threshold. Then we start reducing the Threshold_Amount by 100 each time until it equals to 100. We also reduce Threshold_Days by 1 each time until it equals to 10. We count for each threshold. T1 is the table we have, T2 and T3 are the desired output. I am thinking using loop, however I do not know how to start. Any help are appreciated! Thank you Desired Tables:

Online Status	Offline
Date Last Visited	‎10-05-2018 02:31 PM

Re: Using Loop to count observations that meet conditions

Re: Using Loop to count observations that meet conditions

Using Loop to count observations that meet conditions

Re: Using Loop to count observations that meet conditions

Re: Using Loop to count observations that meet conditions

Using Loop to count observations that meet conditions