topic calculate mean for X and Y for group 2 only in SAS Studio https://communities.sas.com/t5/SAS-Studio/calculate-mean-for-X-and-Y-for-group-2-only/m-p/448824#M5018 <TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>group</TD><TD>subID</TD><TD>pID</TD><TD>X</TD><TD>Y</TD></TR><TR><TD>0</TD><TD>1</TD><TD>1</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>2</TD><TD>2</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>3</TD><TD>3</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>4</TD><TD>4</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>5</TD><TD>5</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>6</TD><TD>6</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>7</TD><TD>7</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>8</TD><TD>8</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>9</TD><TD>9</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>10</TD><TD>10</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>1</TD><TD>11</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>2</TD><TD>12</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>3</TD><TD>13</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>4</TD><TD>14</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>5</TD><TD>15</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>6</TD><TD>16</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>7</TD><TD>17</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>8</TD><TD>18</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>9</TD><TD>19</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>10</TD><TD>20</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>2</TD><TD>1</TD><TD>21</TD><TD>35.55555556</TD><TD>60</TD></TR><TR><TD>2</TD><TD>2</TD><TD>22</TD><TD>30</TD><TD>51</TD></TR><TR><TD>2</TD><TD>3</TD><TD>23</TD><TD>48.88888889</TD><TD>41</TD></TR><TR><TD>2</TD><TD>4</TD><TD>24</TD><TD>46.66666667</TD><TD>38</TD></TR><TR><TD>2</TD><TD>5</TD><TD>25</TD><TD>46</TD><TD>28</TD></TR><TR><TD>2</TD><TD>6</TD><TD>26</TD><TD>28</TD><TD>54.5</TD></TR><TR><TD>2</TD><TD>7</TD><TD>27</TD><TD>88</TD><TD>15</TD></TR><TR><TD>2</TD><TD>8</TD><TD>28</TD><TD>31.11111111</TD><TD>42</TD></TR><TR><TD>2</TD><TD>9</TD><TD>29</TD><TD>20</TD><TD>59</TD></TR><TR><TD>2</TD><TD>10</TD><TD>30</TD><TD>22</TD><TD>76<PRE><CODE class=" language-sas">proc means data=WORK.smuck N mean median MIN P25 P75 QRANGE MAX STD MAXDEC=2; class group; var x y where group NE (0) AND group NE (1) ; run; quit;</CODE></PRE></TD></TR></TBODY></TABLE> Mon, 26 Mar 2018 22:23:39 GMT kcodo 2018-03-26T22:23:39Z calculate mean for X and Y for group 2 only https://communities.sas.com/t5/SAS-Studio/calculate-mean-for-X-and-Y-for-group-2-only/m-p/448824#M5018 <TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>group</TD><TD>subID</TD><TD>pID</TD><TD>X</TD><TD>Y</TD></TR><TR><TD>0</TD><TD>1</TD><TD>1</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>2</TD><TD>2</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>3</TD><TD>3</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>4</TD><TD>4</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>5</TD><TD>5</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>6</TD><TD>6</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>7</TD><TD>7</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>8</TD><TD>8</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>9</TD><TD>9</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>0</TD><TD>10</TD><TD>10</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>1</TD><TD>11</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>2</TD><TD>12</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>3</TD><TD>13</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>4</TD><TD>14</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>5</TD><TD>15</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>6</TD><TD>16</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>7</TD><TD>17</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>8</TD><TD>18</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>9</TD><TD>19</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>1</TD><TD>10</TD><TD>20</TD><TD>-99</TD><TD>-99</TD></TR><TR><TD>2</TD><TD>1</TD><TD>21</TD><TD>35.55555556</TD><TD>60</TD></TR><TR><TD>2</TD><TD>2</TD><TD>22</TD><TD>30</TD><TD>51</TD></TR><TR><TD>2</TD><TD>3</TD><TD>23</TD><TD>48.88888889</TD><TD>41</TD></TR><TR><TD>2</TD><TD>4</TD><TD>24</TD><TD>46.66666667</TD><TD>38</TD></TR><TR><TD>2</TD><TD>5</TD><TD>25</TD><TD>46</TD><TD>28</TD></TR><TR><TD>2</TD><TD>6</TD><TD>26</TD><TD>28</TD><TD>54.5</TD></TR><TR><TD>2</TD><TD>7</TD><TD>27</TD><TD>88</TD><TD>15</TD></TR><TR><TD>2</TD><TD>8</TD><TD>28</TD><TD>31.11111111</TD><TD>42</TD></TR><TR><TD>2</TD><TD>9</TD><TD>29</TD><TD>20</TD><TD>59</TD></TR><TR><TD>2</TD><TD>10</TD><TD>30</TD><TD>22</TD><TD>76<PRE><CODE class=" language-sas">proc means data=WORK.smuck N mean median MIN P25 P75 QRANGE MAX STD MAXDEC=2; class group; var x y where group NE (0) AND group NE (1) ; run; quit;</CODE></PRE></TD></TR></TBODY></TABLE> Mon, 26 Mar 2018 22:23:39 GMT https://communities.sas.com/t5/SAS-Studio/calculate-mean-for-X-and-Y-for-group-2-only/m-p/448824#M5018 kcodo 2018-03-26T22:23:39Z Re: calculate mean for X and Y for group 2 only https://communities.sas.com/t5/SAS-Studio/calculate-mean-for-X-and-Y-for-group-2-only/m-p/448825#M5019 <P>You are only missing a semicolon.</P> Mon, 26 Mar 2018 22:32:40 GMT https://communities.sas.com/t5/SAS-Studio/calculate-mean-for-X-and-Y-for-group-2-only/m-p/448825#M5019 PGStats 2018-03-26T22:32:40Z Re: calculate mean for X and Y for group 2 only https://communities.sas.com/t5/SAS-Studio/calculate-mean-for-X-and-Y-for-group-2-only/m-p/448828#M5020 <P>Thank you <A href="https://communities.sas.com/t5/user/viewprofilepage/user-id/462" target="_self"><SPAN class="login-bold">PGStats</SPAN></A>!</P> Mon, 26 Mar 2018 23:31:42 GMT https://communities.sas.com/t5/SAS-Studio/calculate-mean-for-X-and-Y-for-group-2-only/m-p/448828#M5020 kcodo 2018-03-26T23:31:42Z