Hi All, I require some assistance from you all. I've a table has 10 columns but I require output table based on 2 columns only they are sas_date and amount . And it has data of February to till date. In that I need to keep a condition like if the amount is max for a record then I need the overall rows where the sas_date should be older date. Ex: Sas_date x y z amount 09feb2022 1 2 3 1 01feb2022 1 2 3 5 20mar2022 1 2 3 2 11apr2022 6 6 7 8 24feb2022 6 6 7 9 25mar2022 6 6 7 9 17apr2022 9 8 6 1 19mar2022 9 8. 6. 1 Output table should be: Sas_date. | X. Y. Z. Amount 01feb2022| 1 2. 3. 5 24feb 2022 6. 6. 7. 9 19mar2022 9. 8. 6 1 If the amount has all 1's for every row then the amount should be same but the sas date should be an older date. Thanks. ... View more

Hi All, I hope everyone is doing good. I require some assistance from you all regrading joining two tables based on some condition. I've two tables x and y in x it has 3 columns which are present in table y as well and an extra column is there for y table named amount . These two tables should be joined based on those 3 fields named a,b,c and it should have a condition like If the values of the 3 fields in x doesn't exist in the columns of y table then for those values the amount should be equal to 0 instead of excluding them those who doesn't exist Example table: X - table :. Y - table: a b c a. b. c. amount 1 5 15. 1. 5. 15. 4 2 6 26. 2. 6. 26. 9 3 7 37. 3. 7. 37. 8 4 8 48 Joined table (required table): a. b. c. amount 1. 5. 15. 4 2. 6. 26. 9 3. 7. 37. 8 4. 8. 48. 0 Ps: I apologise there are no dots in the data, please don't consider them. Thankyou. ... View more