topic Re: How to replace values between columns in SAS Programming

How to replace values between columns

superbug — Tue, 14 Jan 2020 19:17:01 GMT

my data is like this

data test;
infile cards truncover;
input peat1 peat2;
datalines;
0 .
3 .
6 .
24 6
15 .
18 0
;

use the following code, I generated two new variables, peat1_ and peat2_.

data test_;
set test;
if 0=<peat1=<6 and peat1 ^=. then peat1_=1;

if 0=<peat2=<6 and peat2 ^=. then peat2_=1;
run;

Now I want to replace values of peat1 with values of peat2_, which SAS function should I use? thanks!

ed_sas_member — Tue, 14 Jan 2020 19:53:15 GMT

Something like this ??

data test_;
	set test;
	if 0=<peat1=<6 and peat1 ^=. then peat1_=1;
	if 0=<peat2=<6 and peat2 ^=. then do;
		peat2_= 1;
		peat1 = 1;
	end;
run;

superbug — Tue, 14 Jan 2020 20:25:12 GMT

thanks. using the code you suggested, the original value of peat1 changed in row 4 and row 6, which is not I wanted.

Also, there's is no difference on peat1_ and peat2_ variables using your code and using my original code.

ed_sas_member — Tue, 14 Jan 2020 20:41:22 GMT

Could you please provide the expected output as it's not clear to me.

According to the IF condition you provided, there is no difference in calculation. I believe there is a mistake somewhere.

best,

Oligolas — Wed, 15 Jan 2020 12:59:41 GMT

if not missing(peat2_) then peat1=peat2_;

superbug — Wed, 15 Jan 2020 14:06:44 GMT

I restructured my data. I'll consider to reach my final results in another way.

Thanks much for your time!

superbug — Wed, 15 Jan 2020 14:11:40 GMT

Thanks much!