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!
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!
You are looking for the SUM function. It ignores missings.
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!
Thank you so much!!! This worked perfectly! I appreciate it. 😊
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.