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

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

newbie_grad — Wed, 31 Jan 2018 21:17:25 GMT

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!

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

novinosrin — Wed, 31 Jan 2018 21:23:13 GMT

assuming baby_id is char var. You could do:

data want;

set have;

sum=sum(of _numeric_);

run;

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

Tom — Wed, 31 Jan 2018 21:24:53 GMT

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;