Hello friends! First of all, I'm a newbie in the SAS world and I'm starting my journey recently, so sorry if I don't explain very well what I need, an thanks for all support. I have a table with various customer purchase data, divided by month. What I need is to see if the customer_Id of the cost_set20 table appears in the subsequent tables (nov20, dec20, jan21, [...] aug21) And then whenever it appears I need to mark in another table the client_id, the last month it appeared, and the number of times it appeared in the query that was made. The truth is that I have no idea how to do this, I understand the logical sequence, but I wouldn't know how to assemble a query that would do this for me.I have a test coming soon for a job in the area and I wanted to get there by understanding how to do this. Thank you all
... View more