topic Re: Array??? in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Array/m-p/152242#M40042 <HTML><HEAD></HEAD><BODY><P>If it's a count then it isn't a sum. No array needed</P><P>the function is N</P><P></P><P>sum= n(of Var1-var7);</P><P></P><P>If the names aren't that nice in reality then us&nbsp; n (varname othervar thisvar thatvar);</P></BODY></HTML> Fri, 21 Mar 2014 17:07:25 GMT ballardw 2014-03-21T17:07:25Z Array??? https://communities.sas.com/t5/SAS-Procedures/Array/m-p/152241#M40041 <HTML><HEAD></HEAD><BODY><P>hi.</P><P>i have 7 variables</P><P>i need to create a SUM variable which counts the number of non missings</P><P></P><P></P><P></P><P>HAVE</P><P>id&nbsp;&nbsp;&nbsp;&nbsp; var1&nbsp;&nbsp; var2&nbsp;&nbsp;&nbsp; var3&nbsp;&nbsp;&nbsp;&nbsp; var4&nbsp;&nbsp; var5&nbsp;&nbsp; var6&nbsp;&nbsp;&nbsp; var7</P><P>101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>102&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><P></P><P></P><P>WANT</P><P></P><P>id&nbsp;&nbsp;&nbsp;&nbsp; var1&nbsp;&nbsp; var2&nbsp;&nbsp;&nbsp; var3&nbsp;&nbsp;&nbsp;&nbsp; var4&nbsp;&nbsp; var5&nbsp;&nbsp; var6&nbsp;&nbsp;&nbsp; var7&nbsp;&nbsp; sum</P><P>101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; .&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P></P><P>Thanks</P></BODY></HTML> Fri, 21 Mar 2014 17:00:28 GMT https://communities.sas.com/t5/SAS-Procedures/Array/m-p/152241#M40041 robertrao 2014-03-21T17:00:28Z Re: Array??? https://communities.sas.com/t5/SAS-Procedures/Array/m-p/152242#M40042 <HTML><HEAD></HEAD><BODY><P>If it's a count then it isn't a sum. No array needed</P><P>the function is N</P><P></P><P>sum= n(of Var1-var7);</P><P></P><P>If the names aren't that nice in reality then us&nbsp; n (varname othervar thisvar thatvar);</P></BODY></HTML> Fri, 21 Mar 2014 17:07:25 GMT https://communities.sas.com/t5/SAS-Procedures/Array/m-p/152242#M40042 ballardw 2014-03-21T17:07:25Z