topic how to test differences in frequencies in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-test-differences-in-frequencies/m-p/863139#M340970 <P>Hi...I am new on SAS communties and I would appreciate help with following data set...I have set with about 14000 IDs regarding specific event that was monitored during 11 years (2010-2020; with different number of IDs per year, for example 1211 IDs in 2010, 1294 in 2011...1007 in 2015, 1105 in 2016,...&nbsp; ), per each ID I have also season, time of the day when event occured, which species was affected and how many individuals of species was affected or dead...something like this</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;YEAR&nbsp; &nbsp; &nbsp; &nbsp;season per year&nbsp; &nbsp; &nbsp; time of day&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;species&nbsp; &nbsp; &nbsp; &nbsp; affected&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dead</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2010&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;summer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;morning&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2010&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; autumn&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; day&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>...</P><P>1212&nbsp; &nbsp; &nbsp; &nbsp; 2011&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;spring&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; night&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>1213&nbsp; &nbsp; &nbsp; &nbsp; 2011</P><P>...</P><P>2033&nbsp; &nbsp; &nbsp; &nbsp;2012&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; winter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; morning&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>2034&nbsp; &nbsp; &nbsp; &nbsp;2013&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; spring&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; morning&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>...</P><P>3535&nbsp; &nbsp; &nbsp; 2014&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; autumn&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; night&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5</P><P>...</P><P>13353&nbsp; &nbsp; 2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; summer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;day&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>&nbsp;</P><P>I would like test is there significant difference between number and/or frequency of affected and dead animals of different species per year, per season within year, per time of day within season...I would appreciate help and suggestions...thanks!</P> Thu, 09 Mar 2023 08:31:38 GMT nika1 2023-03-09T08:31:38Z how to test differences in frequencies https://communities.sas.com/t5/SAS-Programming/how-to-test-differences-in-frequencies/m-p/863139#M340970 <P>Hi...I am new on SAS communties and I would appreciate help with following data set...I have set with about 14000 IDs regarding specific event that was monitored during 11 years (2010-2020; with different number of IDs per year, for example 1211 IDs in 2010, 1294 in 2011...1007 in 2015, 1105 in 2016,...&nbsp; ), per each ID I have also season, time of the day when event occured, which species was affected and how many individuals of species was affected or dead...something like this</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;YEAR&nbsp; &nbsp; &nbsp; &nbsp;season per year&nbsp; &nbsp; &nbsp; time of day&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;species&nbsp; &nbsp; &nbsp; &nbsp; affected&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dead</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2010&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;summer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;morning&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2010&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; autumn&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; day&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>...</P><P>1212&nbsp; &nbsp; &nbsp; &nbsp; 2011&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;spring&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; night&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>1213&nbsp; &nbsp; &nbsp; &nbsp; 2011</P><P>...</P><P>2033&nbsp; &nbsp; &nbsp; &nbsp;2012&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; winter&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; morning&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>2034&nbsp; &nbsp; &nbsp; &nbsp;2013&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; spring&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; morning&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>...</P><P>3535&nbsp; &nbsp; &nbsp; 2014&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; autumn&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; night&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5</P><P>...</P><P>13353&nbsp; &nbsp; 2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; summer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;day&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>&nbsp;</P><P>I would like test is there significant difference between number and/or frequency of affected and dead animals of different species per year, per season within year, per time of day within season...I would appreciate help and suggestions...thanks!</P> Thu, 09 Mar 2023 08:31:38 GMT https://communities.sas.com/t5/SAS-Programming/how-to-test-differences-in-frequencies/m-p/863139#M340970 nika1 2023-03-09T08:31:38Z Re: how to test differences in frequencies https://communities.sas.com/t5/SAS-Programming/how-to-test-differences-in-frequencies/m-p/863769#M341174 <P>Not sure exactly what you are looking for as a result. It it something like this?</P> <PRE><CODE class=" language-sas">data have; infile datalines dsd dlm='|' truncover; input ID YEAR season:$6. time_of_day:$7. species affected dead; datalines; 1|2010|spring|night|3|5|0 2|2010|summer|morning|1|0|1 3|2010|autumn|day|2|1|1 4|2010|winter|morning|1|3|1 5|2011|spring|morning|2|0|1 6|2011|autumn|night|3|2|5 7|2011|summer|day|1|1|1 8|2011|winter|morning|1|3|1 ; proc means data=have sum maxdec=0; var species affected dead; class year; run; proc means data=have sum maxdec=0; var species affected dead; class season; run; proc means data=have sum maxdec=0; var species affected dead; class time_of_day; run; </CODE></PRE> <DIV class="branch"> <DIV> <DIV align="left"> <TABLE class="table" summary="Procedure Means: Summary statistics" frame="box" rules="all" cellspacing="0" cellpadding="5"> <THEAD> <TR> <TH class="r b header" scope="col">YEAR</TH> <TH class="r b header" scope="col">N Obs</TH> <TH class="l b header" scope="col">Variable</TH> <TH class="r b header" scope="col">Sum</TH> </TR> </THEAD> <TBODY> <TR> <TH class="r t data">2010</TH> <TH class="r t data">4</TH> <TH class="l stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TH class="l data top_stacked_value">species</TH> </TR> <TR> <TH class="l data middle_stacked_value">affected</TH> </TR> <TR> <TH class="l data bottom_stacked_value">dead</TH> </TR> </TBODY> </TABLE> </TH> <TD class="r stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TD class="r data top_stacked_value">7</TD> </TR> <TR> <TD class="r data middle_stacked_value">9</TD> </TR> <TR> <TD class="r data bottom_stacked_value">3</TD> </TR> </TBODY> </TABLE> </TD> </TR> <TR> <TH class="r t data">2011</TH> <TH class="r t data">4</TH> <TH class="l stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TH class="l data top_stacked_value">species</TH> </TR> <TR> <TH class="l data middle_stacked_value">affected</TH> </TR> <TR> <TH class="l data bottom_stacked_value">dead</TH> </TR> </TBODY> </TABLE> </TH> <TD class="r stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TD class="r data top_stacked_value">7</TD> </TR> <TR> <TD class="r data middle_stacked_value">6</TD> </TR> <TR> <TD class="r data bottom_stacked_value">8</TD> </TR> </TBODY> </TABLE> </TD> </TR> </TBODY> </TABLE> </DIV> </DIV> </DIV> <DIV class="branch"> <P>&nbsp;</P> <DIV> <DIV align="left"> <TABLE class="table" summary="Procedure Means: Summary statistics" frame="box" rules="all" cellspacing="0" cellpadding="5"><COLGROUP> <COL /> <COL /> <COL /></COLGROUP> <COLGROUP> <COL /></COLGROUP> <THEAD> <TR> <TH class="l b header" scope="col">season</TH> <TH class="r b header" scope="col">N Obs</TH> <TH class="l b header" scope="col">Variable</TH> <TH class="r b header" scope="col">Sum</TH> </TR> </THEAD> <TBODY> <TR> <TH class="l t data">autumn</TH> <TH class="r t data">2</TH> <TH class="l stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TH class="l data top_stacked_value">species</TH> </TR> <TR> <TH class="l data middle_stacked_value">affected</TH> </TR> <TR> <TH class="l data bottom_stacked_value">dead</TH> </TR> </TBODY> </TABLE> </TH> <TD class="r stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TD class="r data top_stacked_value">5</TD> </TR> <TR> <TD class="r data middle_stacked_value">3</TD> </TR> <TR> <TD class="r data bottom_stacked_value">6</TD> </TR> </TBODY> </TABLE> </TD> </TR> <TR> <TH class="l t data">spring</TH> <TH class="r t data">2</TH> <TH class="l stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TH class="l data top_stacked_value">species</TH> </TR> <TR> <TH class="l data middle_stacked_value">affected</TH> </TR> <TR> <TH class="l data bottom_stacked_value">dead</TH> </TR> </TBODY> </TABLE> </TH> <TD class="r stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TD class="r data top_stacked_value">5</TD> </TR> <TR> <TD class="r data middle_stacked_value">5</TD> </TR> <TR> <TD class="r data bottom_stacked_value">1</TD> </TR> </TBODY> </TABLE> </TD> </TR> <TR> <TH class="l t data">summer</TH> <TH class="r t data">2</TH> <TH class="l stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TH class="l data top_stacked_value">species</TH> </TR> <TR> <TH class="l data middle_stacked_value">affected</TH> </TR> <TR> <TH class="l data bottom_stacked_value">dead</TH> </TR> </TBODY> </TABLE> </TH> <TD class="r stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TD class="r data top_stacked_value">2</TD> </TR> <TR> <TD class="r data middle_stacked_value">1</TD> </TR> <TR> <TD class="r data bottom_stacked_value">2</TD> </TR> </TBODY> </TABLE> </TD> </TR> <TR> <TH class="l t data">winter</TH> <TH class="r t data">2</TH> <TH class="l stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TH class="l data top_stacked_value">species</TH> </TR> <TR> <TH class="l data middle_stacked_value">affected</TH> </TR> <TR> <TH class="l data bottom_stacked_value">dead</TH> </TR> </TBODY> </TABLE> </TH> <TD class="r stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TD class="r data top_stacked_value">2</TD> </TR> <TR> <TD class="r data middle_stacked_value">6</TD> </TR> <TR> <TD class="r data bottom_stacked_value">2</TD> </TR> </TBODY> </TABLE> </TD> </TR> </TBODY> </TABLE> </DIV> </DIV> </DIV> <DIV class="branch"><BR /> <DIV> <DIV align="left"> <TABLE class="table" summary="Procedure Means: Summary statistics" frame="box" rules="all" cellspacing="0" cellpadding="5"><COLGROUP> <COL /> <COL /> <COL /></COLGROUP> <COLGROUP> <COL /></COLGROUP> <THEAD> <TR> <TH class="l b header" scope="col">time_of_day</TH> <TH class="r b header" scope="col">N Obs</TH> <TH class="l b header" scope="col">Variable</TH> <TH class="r b header" scope="col">Sum</TH> </TR> </THEAD> <TBODY> <TR> <TH class="l t data">day</TH> <TH class="r t data">2</TH> <TH class="l stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TH class="l data top_stacked_value">species</TH> </TR> <TR> <TH class="l data middle_stacked_value">affected</TH> </TR> <TR> <TH class="l data bottom_stacked_value">dead</TH> </TR> </TBODY> </TABLE> </TH> <TD class="r stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TD class="r data top_stacked_value">3</TD> </TR> <TR> <TD class="r data middle_stacked_value">2</TD> </TR> <TR> <TD class="r data bottom_stacked_value">2</TD> </TR> </TBODY> </TABLE> </TD> </TR> <TR> <TH class="l t data">morning</TH> <TH class="r t data">4</TH> <TH class="l stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TH class="l data top_stacked_value">species</TH> </TR> <TR> <TH class="l data middle_stacked_value">affected</TH> </TR> <TR> <TH class="l data bottom_stacked_value">dead</TH> </TR> </TBODY> </TABLE> </TH> <TD class="r stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TD class="r data top_stacked_value">5</TD> </TR> <TR> <TD class="r data middle_stacked_value">6</TD> </TR> <TR> <TD class="r data bottom_stacked_value">4</TD> </TR> </TBODY> </TABLE> </TD> </TR> <TR> <TH class="l t data">night</TH> <TH class="r t data">2</TH> <TH class="l stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TH class="l data top_stacked_value">species</TH> </TR> <TR> <TH class="l data middle_stacked_value">affected</TH> </TR> <TR> <TH class="l data bottom_stacked_value">dead</TH> </TR> </TBODY> </TABLE> </TH> <TD class="r stacked_cell data"> <TABLE border="0" width="100%" cellspacing="0" cellpadding="5"> <TBODY> <TR> <TD class="r data top_stacked_value">6</TD> </TR> <TR> <TD class="r data middle_stacked_value">7</TD> </TR> <TR> <TD class="r data bottom_stacked_value">5</TD> </TR> </TBODY> </TABLE> </TD> </TR> </TBODY> </TABLE> </DIV> </DIV> </DIV> <P>&nbsp;</P> Mon, 13 Mar 2023 12:46:02 GMT https://communities.sas.com/t5/SAS-Programming/how-to-test-differences-in-frequencies/m-p/863769#M341174 SASJedi 2023-03-13T12:46:02Z