09-28-2017 01:09 PM
Hi, I need your help solving this issue:
I have client_id with multiple date of service and I need to place in between the correct range of dates, the date that client make a payment, so for example:
Client DateOf Service
I think I can rank the dates in table 1 and stablish start and end date, maybe? Any help will be awesome!
09-28-2017 01:14 PM
All your dates need to be actual SAS dates, not text strings.
And your data sets need to be in sorted order.
With those conditions in place, this would be one way to rearrange the pieces:
set table1 (rename=(DateofService=Date) in=in1)
table2 (rename=(Payment=Date) in=in2);
by Client Date;
if in1 then Action='Service';
Try it, see if you like what you get. (If you don't like it, you might have to design what you would like the solution to look like before programming can begin.)