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!
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;
assuming baby_id is char var. You could do:
data want;
set have;
sum=sum(of _numeric_);
run;
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.