BookmarkSubscribeRSS Feed
MBruns
Calcite | Level 5
trying to get a report of rules triggered by week then in a weeku5.  date format having issues. ignore  "week"  column 
cant seem to get variations of group by and of Week(time_stamp) and other ways to work? need some help.
Obs app_id procs_date rule_id time_stamp decision_tp_c week12345678910
1091755801JAN2021:00:02:30.457CRNSF09FEB2021:00:16:41.813DECLN1001341
1091755801JAN2021:00:02:30.457HATNF05FEB2021:00:17:30.287DECLN1001341
1091755801JAN2021:00:02:30.457EMAILAGE05FEB2021:00:17:31.163DECLN1001341
1091755901JAN2021:00:03:01.437NODEP06FEB2021:00:16:24.983DECLN1001341
1091756001JAN2021:00:07:05.450NODEP06FEB2021:00:16:24.797DECLN1001341
1091756101JAN2021:00:09:42.347NODEP06FEB2021:00:16:24.610DECLN1001341
1091756201JAN2021:00:15:01.203CRNSF15JAN2021:00:17:36.520DECLN1001341
1091756201JAN2021:00:15:01.203HATNF01JAN2021:00:15:08.920DECLN1001341
1091756201JAN2021:00:15:01.203DUPADD01JAN2021:00:15:10.453DECLN1001341
1091756301JAN2021:00:16:44.987EMAILAGE01JAN2021:00:16:52.377DECLN1001341

 

 

 

 

 

2 REPLIES 2
MBruns
Calcite | Level 5
looking to keep it in a cube format
• Week
• Rule
• Decision type
• Count
AMSAS
SAS Super FREQ

Sorry but I don't understand what you are attempting to do from your description 
Can you post, sample data of what you have, what you want and any code you have already tried.

If your have data is in a SAS dataset you can use this macro to convert it into code to paste here
Data2DataStep Maco instructions
If not then generate the code yourself with infile/input/card statements

Thanks

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 433 views
  • 0 likes
  • 2 in conversation