- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Please try below code
Data test; /* Creating new dataset */
set Student; /* Original data set */
Tot = sum(English , Hindi);
Run;
Jag
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Please try below code
Data test; /* Creating new dataset */
set Student; /* Original data set */
Tot = sum(English , Hindi);
Run;
Jag
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Jag, its working
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Jag
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.