## How to sum certain columns in all rows and make a new column with the sum value.

Solved
Occasional Contributor
Posts: 9

# How to sum certain columns in all rows and make a new column with the sum value.

Hello everyone!

I am trying to add the appearance, pulse, grimace, activity, and respiration columns for each baby ID and make a new sum column like below:

So the first number in the sum column would be 7, the second number would be 6 and so on.

This is the code I made up:

``````data Question2a;
title 'Minute1 dataset plus score';
set Homework.minute1;
sum = 'Appearance'+'Pulse'+'Grimace'+'Activity'+'Respiration';
keep Baby_ID Appearance Pulse Grimace Activity Respiration sum;
run;
proc print data=question2a;
run;``````

Any help would be greatly appreciated!

Thanks!

Accepted Solutions
Solution
‎02-01-2018 12:02 PM
Super User
Posts: 7,932

## Re: How to sum certain columns in all rows and make a new column with the sum value.

You cannot perform arithmetic on string literals. Use the variable names. If you have the VALIDVARNAME option set to any then you could use name literals to allow you to program with a name that include embedded spaces and other non-standard things.

You might want to also check how the SUM() function differs from simple + operator.  (Hint what do you want for SUM when there is no value for PULSE?)

``````data Question2a;
set Homework.minute1;
sum = sum( of Appearance Pulse Grimace Activity Respiration);
run;

title 'Minute1 dataset plus score';
proc print data=question2a;
var Baby_ID Appearance Pulse Grimace Activity Respiration sum;
run;``````

All Replies
PROC Star
Posts: 1,558

## Re: How to sum certain columns in all rows and make a new column with the sum value.

assuming baby_id is char var. You could do:

data want;

set have;

sum=sum(of _numeric_);

run;

Solution
‎02-01-2018 12:02 PM
Super User
Posts: 7,932

## Re: How to sum certain columns in all rows and make a new column with the sum value.

You cannot perform arithmetic on string literals. Use the variable names. If you have the VALIDVARNAME option set to any then you could use name literals to allow you to program with a name that include embedded spaces and other non-standard things.

You might want to also check how the SUM() function differs from simple + operator.  (Hint what do you want for SUM when there is no value for PULSE?)

``````data Question2a;
set Homework.minute1;
sum = sum( of Appearance Pulse Grimace Activity Respiration);
run;

title 'Minute1 dataset plus score';
proc print data=question2a;
var Baby_ID Appearance Pulse Grimace Activity Respiration sum;
run;``````
☑ This topic is solved.

Discussion stats
• 2 replies
• 79 views
• 2 likes
• 3 in conversation