topic Re: How to calculate the mean of a number of variables in one simple statement? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-calculate-the-mean-of-a-number-of-variables-in-one-simple/m-p/180865#M265145 <HTML><HEAD></HEAD><BODY><P>If I understand it correctly, you are trying to mean across the variables. May be this can generate the desired output.</P><P></P><P>data want;</P><P>set have;</P><P>array list{*} _numeric_;</P><P>mean=mean(of list{*});</P><P>run;</P></BODY></HTML> Sat, 30 Aug 2014 22:06:09 GMT stat_sas 2014-08-30T22:06:09Z How to calculate the mean of a number of variables in one simple statement? https://communities.sas.com/t5/SAS-Programming/How-to-calculate-the-mean-of-a-number-of-variables-in-one-simple/m-p/180864#M265144 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>If I have 100 numeric variables and I'd like to calculate the average while creating a new variable Mean, is there a simple statement that I can use in the data step instead of typing the variable names one by one and then calculate the average?</P><P></P><P>Thank you.</P></BODY></HTML> Sat, 30 Aug 2014 21:41:56 GMT https://communities.sas.com/t5/SAS-Programming/How-to-calculate-the-mean-of-a-number-of-variables-in-one-simple/m-p/180864#M265144 chouchou 2014-08-30T21:41:56Z Re: How to calculate the mean of a number of variables in one simple statement? https://communities.sas.com/t5/SAS-Programming/How-to-calculate-the-mean-of-a-number-of-variables-in-one-simple/m-p/180865#M265145 <HTML><HEAD></HEAD><BODY><P>If I understand it correctly, you are trying to mean across the variables. May be this can generate the desired output.</P><P></P><P>data want;</P><P>set have;</P><P>array list{*} _numeric_;</P><P>mean=mean(of list{*});</P><P>run;</P></BODY></HTML> Sat, 30 Aug 2014 22:06:09 GMT https://communities.sas.com/t5/SAS-Programming/How-to-calculate-the-mean-of-a-number-of-variables-in-one-simple/m-p/180865#M265145 stat_sas 2014-08-30T22:06:09Z Re: How to calculate the mean of a number of variables in one simple statement? https://communities.sas.com/t5/SAS-Programming/How-to-calculate-the-mean-of-a-number-of-variables-in-one-simple/m-p/180866#M265146 <HTML><HEAD></HEAD><BODY><P>Look into SAS Variable Lists</P><P></P><P><A class="active_link" href="http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p0wphcpsfgx6o7n1sjtqzizp1n39.htm" title="http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p0wphcpsfgx6o7n1sjtqzizp1n39.htm">http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p0wphcpsfgx6o7n1sjtqzizp1n39.htm</A></P><P></P><P>Functions such as <STRONG>mean</STRONG> can accept variable lists as arguments. For example <STRONG>z = mean( of a--f, of x:);</STRONG> will compute the mean of variables <STRONG>a</STRONG> throuhg <STRONG>f</STRONG> in your variable list and of all variables with names starting with <STRONG>x</STRONG>. The variable list notation can save you a lot of typing and make your code more general.</P><P></P><P>PG</P></BODY></HTML> Sun, 31 Aug 2014 00:52:49 GMT https://communities.sas.com/t5/SAS-Programming/How-to-calculate-the-mean-of-a-number-of-variables-in-one-simple/m-p/180866#M265146 PGStats 2014-08-31T00:52:49Z