11-04-2013 08:43 AM
Hey I need some help formatting some data I was recently given.
I need to see all the days the customer had the product. Is there an easy way to do this or do I need to write some loops?
11-04-2013 08:52 AM
For now I'm only trying to find the total days overlap in multiple products by customer. The output would be 30 dates.
Ex. for row one:
customer product possession_date
a r1 10/11/13
a r1 10/12/13
a r1 10/13/13
11-04-2013 09:02 AM
Can't really see the end product. But if you want that desired output, I think a do-loop is the tool.
After outputting a row for each date, re-sort the table on customer, possession_date and product, and then use a data step with BY and first./last.-logic to create your desired output.
11-04-2013 10:42 AM
input customer$ product$ purchase_date : mmddyy10. days_supply;
format purchase_date mmddyy10.;
a R1 10/11/13 30
a R2 10/11/13 30
b R1 02/15/13 30
b R2 03/15/13 30
b R3 04/15/13 60
do possession_date= purchase_date to intnx('day',days_supply,purchase_date);
format possession_date mmddyy10.;