Hi all,   I am looking for a datastep which would rank rows based on few conditions. Table contains customers and dates(of some action). columns = Customer_id and Date.  I want to create ranking based on the condition - if difference between dates is higher than e.g. 50 then increase rank by 1. If the difference between dates is lower than 50 then keep rank from previous row. For each customer (one customer has several records with different dates)...   I have got this, where section is the desired ranking column.   %let day = 50; data test (keep=Cust_ID date new section); set atest.test ; format new best12.; format date1 date9.; by cust_id ; date1=lag((date)) ; new=(date)-date1; if first.cust_id then new=0 ; if not first.cust_id and new=&day. then do; section=1; section = section +1; end; run;   Thanks for your help J ... View more

Hello,   I would like to ask you help me with one excercise.   I want to calculate nr of days between given Dates selection (date when some transaction happened) for each customer id applying additional conditions: 1. Check if the difference is higher than 90 days, if yes, put only 90 2. If customer continues with the transactions then start counting from beggining and flag this a s a new section 3. Check the last day for which this calculation is valid 31.12.2015   Example of the output is attached.   Can you please write the SAS code which would give me desire output? Thanks a lot Jariny ... View more