Hi All,
I hope this message finds you well. Please assist me with my below query.
I want to overwrite an existing table with updated information. I only want to overwrite a 1,000 accounts, and not the whole table of 20,000. I have the following:
Existing table:
account | action | debtor |
1 | paid up | You |
2 | paid up | You |
3 | paid up | You |
4 | paid up | You |
5 | paid up | You |
6 | cure | ABA |
7 | cure | ACA |
8 | arrears | AKL |
Desired output:
account | action | debtor |
1 | close | ' '' |
2 | close | ' '' |
3 | close | ' '' |
4 | close | ' '' |
5 | close | ' '' |
6 | cure | ABA |
7 | cure | ACA |
8 | arrears | AKL |
Please supply data for source and update datasets in usable form, as I have already shown you in https://communities.sas.com/t5/New-SAS-User/Summarize-data-using-SQL/m-p/592936
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.