topic Re: Updating/Overwriting Data in New SAS User

Updating/Overwriting Data

MagD — Wed, 27 Nov 2019 09:46:08 GMT

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

Re: Updating/Overwriting Data

Kurt_Bremser — Wed, 27 Nov 2019 09:49:33 GMT

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

Re: Updating/Overwriting Data

MagD — Wed, 27 Nov 2019 09:56:20 GMT

Hi KurtBremser,

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

Re: Updating/Overwriting Data

sustagens — Wed, 27 Nov 2019 10:01:42 GMT

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

Re: Updating/Overwriting Data

MagD — Wed, 27 Nov 2019 10:07:50 GMT

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;

Re: Updating/Overwriting Data

sustagens — Thu, 28 Nov 2019 00:52:28 GMT

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