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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

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:

output.jpg

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
3 weeks ago
Super User
Super User
Posts: 7,393

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

Posted in reply to newbie_grad

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;

View solution in original post


All Replies
PROC Star
Posts: 827

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

Posted in reply to newbie_grad

assuming baby_id is char var. You could do:

 

data want;

set have;

sum=sum(of _numeric_);

run;

Solution
3 weeks ago
Super User
Super User
Posts: 7,393

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

Posted in reply to newbie_grad

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.

Need further help from the community? Please ask a new question.

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