🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 12-04-2019 05:33 PM
(1050 views)
I am currently trying to create a new variable in my data set called called 'points'. The variable 'points' is the sum of multiple variables. My current code is working fine to sum the data, however I have a problem: I only want to sum the data when all the variables are not blank.
Score = sum(300, A, B, C, D);
How can I modify my code so that I only sum the data when A, B, C & D are not blank.
Thanks!
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
if nmiss( A, B, C, D) = 0 then Score = sum(300, A, B,C, D);
alternatively
Score = 300 + a +b +c +d;
will return missing if any of a, b, c or d are missing.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
if nmiss( A, B, C, D) = 0 then Score = sum(300, A, B,C, D);
alternatively
Score = 300 + a +b +c +d;
will return missing if any of a, b, c or d are missing.