topic Re: How to add two numeric columns together, add them if they are two values into one column? in SAS Enterprise Guide

How to add two numeric columns together, add them if they are two values into one column?

andimo89 — Thu, 24 Sep 2020 20:43:17 GMT

Hello,

Relatively new to SAS Enterprise guide. I am trying to add two columns together into one but would like to add the values if there are no missing values. When there are missing values I would like a 0 in its place.

Example:

This is what I could like:

Column 1 Column 2 New Column

4 6 10

0 0 0

1 0 1

0 1 1

I have tried coalesce(t1.Column 1,t1.Column 2) but this does not add the values.

Thank you in advance!

Re: How to add two numeric columns together, add them if they are two values into one column?

CurtisMackWSIPP — Thu, 24 Sep 2020 20:49:29 GMT

You are looking for the SUM function. It ignores missings.

Re: How to add two numeric columns together, add them if they are two values into one column?

CurtisMackWSIPP — Thu, 24 Sep 2020 20:51:29 GMT

It look like you are in a SQL statement. There are two SUM statements. With one parameter, it sums across rows. If it has more than one, it sums within the row.

Re: How to add two numeric columns together, add them if they are two values into one column?

andimo89 — Thu, 24 Sep 2020 21:01:07 GMT

Hi CurtisMackOFM,

Thanks for the reply. I am currently using the GUI for the advanced expression capability in SAS EG. But row sum might be the way to go.

Re: How to add two numeric columns together, add them if they are two values into one column?

Reeza — Thu, 24 Sep 2020 21:17:07 GMT

You need to have two calculations, a SUM to do the addition and a COALESCE to replace with 0 if missing.

coalesce(sum(t1.Column 1,t1.Column 2), 0)

@andimo89 wrote:

Hello,

Relatively new to SAS Enterprise guide. I am trying to add two columns together into one but would like to add the values if there are no missing values. When there are missing values I would like a 0 in its place.

Example:

This is what I could like:

Column 1 Column 2 New Column

4 6 10

0 0 0

1 0 1

0 1 1

I have tried coalesce(t1.Column 1,t1.Column 2) but this does not add the values.

Thank you in advance!

Re: How to add two numeric columns together, add them if they are two values into one column?

andimo89 — Thu, 24 Sep 2020 21:24:45 GMT

Thank you so much!!! This worked perfectly! I appreciate it. 😊