Updating/Overwriting Data

[MagD]

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

[Kurt_Bremser]

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 

[MagD]

Hi KurtBremser,

I found a solution. It's not very efficient but it works. Thank you for wiling to help me.

[sustagens]

Should the update be made whenever the value of action is "paid up"? or is it dependent on the account?

[MagD]

Hi sustagens

I found a solution, not very efficient though. I imported the accounts that needed to be changed then used the data step to update the variables.

data test;
set Hello;
if account in
(1
2
3
4) then action = ''close'';
run;

data Final;
set test;
if action = ''closed'' then debtor = " ";
run;

[sustagens]

If it works then all good! It doesn't have to be complicated every time. All the best!