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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.