topic Re: Basic SAS program in New SAS User https://communities.sas.com/t5/New-SAS-User/Basic-SAS-program/m-p/568162#M11625 <P>Instead of</P> <PRE><CODE class=" language-sas">(english + math + history +science)</CODE></PRE> <P>use</P> <PRE><CODE class=" language-sas">sum(english,math,history,science)</CODE></PRE> <P>and you will only get a missing value if&nbsp;<EM>all</EM> values are missing.</P> Sat, 22 Jun 2019 21:18:13 GMT Kurt_Bremser 2019-06-22T21:18:13Z Basic SAS program https://communities.sas.com/t5/New-SAS-User/Basic-SAS-program/m-p/568161#M11624 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="D5.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/30470iACDA09395AC2E052/image-size/large?v=v2&amp;px=999" role="button" title="D5.png" alt="D5.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="D6.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/30471i5D32C63AAFDEA928/image-size/large?v=v2&amp;px=999" role="button" title="D6.png" alt="D6.png" /></span></P><P>I am trying some very basic SAS programs. It calculates the average of scores obtained in 4 subjects. One of the scores is missing in an observation and hence the average is not getting calculated. How do I overcome this?</P><P>I have attached a screenshot of my code and output. It is extremely simple. Kindly help.</P><PRE><CODE class=" language-sas">data scores; infile "/folders/myfolders/71442_example/scores.txt"; input gender $ english math history science; avg = (english + math + history +science)/4; run; proc print data=scores; run;</CODE></PRE><P>This is the data:</P><P>M 80 82 85 88</P><P>F 94 92 88 96</P><P>M 96 88 89 92</P><P>F 95 . 92 92</P> Sat, 22 Jun 2019 21:07:20 GMT https://communities.sas.com/t5/New-SAS-User/Basic-SAS-program/m-p/568161#M11624 cy_th 2019-06-22T21:07:20Z Re: Basic SAS program https://communities.sas.com/t5/New-SAS-User/Basic-SAS-program/m-p/568162#M11625 <P>Instead of</P> <PRE><CODE class=" language-sas">(english + math + history +science)</CODE></PRE> <P>use</P> <PRE><CODE class=" language-sas">sum(english,math,history,science)</CODE></PRE> <P>and you will only get a missing value if&nbsp;<EM>all</EM> values are missing.</P> Sat, 22 Jun 2019 21:18:13 GMT https://communities.sas.com/t5/New-SAS-User/Basic-SAS-program/m-p/568162#M11625 Kurt_Bremser 2019-06-22T21:18:13Z