Hi Community,
I have a data that shows the total collections for a specific customer, who experienced a reopening of their order after it was closed. I need from that data to obtain the collections for the reporting month. Here is what I have:
82.44
And here is what I need (the last column):
many thanks,
Altijani
I suspect this example will not generalize to your actual data. Can you provide a more robust example?
If it does generalize, then you can use something like:
if put(collection_date, yymm6.) = put(date, yymm6.) then this_month = ever_collected;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Latest Updates
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!