https://communities.sas.com/t5/New-SAS-User/getting-a-count-of-rule-id-Triggers-by-week-with-Time-stamp-and/m-p/789626#M32420 looking to keep it in a cube format<BR />• Week<BR />• Rule<BR />• Decision type<BR />• Count<BR /> Wed, 12 Jan 2022 01:04:13 GMT MBruns 2022-01-12T01:04:13Z https://communities.sas.com/t5/New-SAS-User/getting-a-count-of-rule-id-Triggers-by-week-with-Time-stamp-and/m-p/789625#M32419 <DIV class=""><DIV align="center">trying to get a report of rules triggered by week then in a&nbsp;weeku5.&nbsp; date format having issues. ignore&nbsp; "week"&nbsp; column&nbsp;</DIV><DIV align="center">cant seem to get variations of group by and of Week(time_stamp) and other ways to work? need some help.<BR />Obs app_id procs_date rule_id time_stamp decision_tp_c week12345678910 <TABLE cellspacing="0" cellpadding="5"><TBODY><TR><TD>10917558</TD><TD>01JAN2021:00:02:30.457</TD><TD>CRNSF</TD><TD>09FEB2021:00:16:41.813</TD><TD>DECLN</TD><TD>1001341</TD></TR><TR><TD>10917558</TD><TD>01JAN2021:00:02:30.457</TD><TD>HATNF</TD><TD>05FEB2021:00:17:30.287</TD><TD>DECLN</TD><TD>1001341</TD></TR><TR><TD>10917558</TD><TD>01JAN2021:00:02:30.457</TD><TD>EMAILAGE</TD><TD>05FEB2021:00:17:31.163</TD><TD>DECLN</TD><TD>1001341</TD></TR><TR><TD>10917559</TD><TD>01JAN2021:00:03:01.437</TD><TD>NODEP</TD><TD>06FEB2021:00:16:24.983</TD><TD>DECLN</TD><TD>1001341</TD></TR><TR><TD>10917560</TD><TD>01JAN2021:00:07:05.450</TD><TD>NODEP</TD><TD>06FEB2021:00:16:24.797</TD><TD>DECLN</TD><TD>1001341</TD></TR><TR><TD>10917561</TD><TD>01JAN2021:00:09:42.347</TD><TD>NODEP</TD><TD>06FEB2021:00:16:24.610</TD><TD>DECLN</TD><TD>1001341</TD></TR><TR><TD>10917562</TD><TD>01JAN2021:00:15:01.203</TD><TD>CRNSF</TD><TD>15JAN2021:00:17:36.520</TD><TD>DECLN</TD><TD>1001341</TD></TR><TR><TD>10917562</TD><TD>01JAN2021:00:15:01.203</TD><TD>HATNF</TD><TD>01JAN2021:00:15:08.920</TD><TD>DECLN</TD><TD>1001341</TD></TR><TR><TD>10917562</TD><TD>01JAN2021:00:15:01.203</TD><TD>DUPADD</TD><TD>01JAN2021:00:15:10.453</TD><TD>DECLN</TD><TD>1001341</TD></TR><TR><TD>10917563</TD><TD>01JAN2021:00:16:44.987</TD><TD>EMAILAGE</TD><TD>01JAN2021:00:16:52.377</TD><TD>DECLN</TD><TD>1001341</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P></DIV></DIV> Wed, 12 Jan 2022 00:36:15 GMT https://communities.sas.com/t5/New-SAS-User/getting-a-count-of-rule-id-Triggers-by-week-with-Time-stamp-and/m-p/789625#M32419 MBruns 2022-01-12T00:36:15Z https://communities.sas.com/t5/New-SAS-User/getting-a-count-of-rule-id-Triggers-by-week-with-Time-stamp-and/m-p/789626#M32420 looking to keep it in a cube format<BR />• Week<BR />• Rule<BR />• Decision type<BR />• Count<BR /> Wed, 12 Jan 2022 01:04:13 GMT https://communities.sas.com/t5/New-SAS-User/getting-a-count-of-rule-id-Triggers-by-week-with-Time-stamp-and/m-p/789626#M32420 MBruns 2022-01-12T01:04:13Z https://communities.sas.com/t5/New-SAS-User/getting-a-count-of-rule-id-Triggers-by-week-with-Time-stamp-and/m-p/789757#M32430 <P>Sorry but I don't understand what you are attempting to do from your description&nbsp;<BR />Can you post, sample data of what you have, what you want and any code you have already tried.</P> <P>If your have data is in a SAS dataset you can use this macro to convert it into code to paste here<BR /><A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_blank">Data2DataStep Maco instructions</A><BR />If not then generate the code yourself with infile/input/card statements</P> <P>Thanks</P> Wed, 12 Jan 2022 17:08:46 GMT https://communities.sas.com/t5/New-SAS-User/getting-a-count-of-rule-id-Triggers-by-week-with-Time-stamp-and/m-p/789757#M32430 AMSAS 2022-01-12T17:08:46Z