topic Re: Adding 2 numeric variable using data Step (not in Proc SQL) in SAS Procedures

Adding 2 numeric variable using data Step (not in Proc SQL)

spsivamca — Fri, 22 Feb 2019 12:46:02 GMT

I have data set loaded by CSV files having student marks (Engilish and Hindi )

But now I want to add English and Hindi marks and assign it to Tot variable

I tried this below code but its not working

Data test; /* Creating new dataset */

set Student; /* Original data set */

Tot = English + Hindi;

Run;

the above code is not working

Kindly help me out on this

Thanks!

Re: Adding 2 numeric variable using data Step (not in Proc SQL)

Jagadishkatam — Fri, 22 Feb 2019 12:52:37 GMT

Please try below code

Data test;   /* Creating new dataset */
set Student; /* Original data set */
Tot = sum(English , Hindi);
Run;

Re: Adding 2 numeric variable using data Step (not in Proc SQL)

spsivamca — Fri, 22 Feb 2019 12:59:32 GMT

Thanks Jag, its working

Re: Adding 2 numeric variable using data Step (not in Proc SQL)

Jagadishkatam — Fri, 22 Feb 2019 13:28:59 GMT

Could you mark as correct answer if it helped. So that it will helps others

Re: Adding 2 numeric variable using data Step (not in Proc SQL)

RW9 — Fri, 22 Feb 2019 13:39:07 GMT

Just to note for future, saying something "does not work" does not provide any information. In this instance, "does not work" means that you have data where one or the other result is missing, when using + a missing in either result means the output will be . (missing). This does not mean it is not working, but just not working as you expect it to, its all in the documentation. In this instance the sum() function ignores missing values, and returns either the one number, or the sum of both of them - again per documentation.