topic Re: merging data into a single column in New SAS User

merging data into a single column

lmyers2 — Thu, 21 Nov 2019 14:29:14 GMT

Hello,

I have the following data structure and am wondering how to get the second data structure from SAS.

What I have:

Case Payment1 Payment2

1 $100 .

2 . $200

3 $300 .

What I want:

Case PaymentNew

1 $100

2 $200

3 $300

In this particular case, payment 1 and 2 are mutually exclusive so only one (not both) is paid per case.

Thanks

Laura

Re: merging data into a single column

novinosrin — Thu, 21 Nov 2019 14:30:24 GMT

Hi @lmyers2 Use coalesce function

Re: merging data into a single column

PeterClemmensen — Thu, 21 Nov 2019 14:31:55 GMT

Do like this

data have;
input Case Payment1 Payment2;
datalines;
1 100 .
2 . 200 
3 300 .
;

data want;
	set have;
	Payment=coalesce(of Payment:);
    keep Case Payment;
run;

Result:

Case  Payment 
1     100
2     200
3     300

Re: merging data into a single column

SuryaKiran — Thu, 21 Nov 2019 15:20:50 GMT

Hello,

Will you be having only one payment and the rest are missing? Then as others suggested coalesce will work fine, but if you have multiple payments and would like to sum them then use sum() function which ignores missing values.

data want;
	set have;
	Payment=sum(of Payment:);
    keep Case Payment;
run;