Date Range by Day

Accepted Solution Solved
Reply
Valued Guide
Posts: 613
Accepted Solution

Date Range by Day

Is there a way to group a date range by day.  I’m trying to query the number of reports ran per day.  This returns the number of reports run in total.

 

proc sql;
select muser, count(*)
from cpy_sp_log
where rundte >= "19MAY2015"d
group by muser
;
quit;


Accepted Solutions
Solution
‎06-07-2016 09:20 AM
Super User
Super User
Posts: 9,599

Re: Date Range by Day

Posted in reply to DavidPhillips2

Maybe I miss something but would this not suffice:

proc sql;
  select  MUSER,
          RUNDTE,
          count(*) as RES
  from    CPY_SP_LOG
  group by MUSER,
           RUNDTE;
quit;

View solution in original post


All Replies
Solution
‎06-07-2016 09:20 AM
Super User
Super User
Posts: 9,599

Re: Date Range by Day

Posted in reply to DavidPhillips2

Maybe I miss something but would this not suffice:

proc sql;
  select  MUSER,
          RUNDTE,
          count(*) as RES
  from    CPY_SP_LOG
  group by MUSER,
           RUNDTE;
quit;
Valued Guide
Posts: 613

Re: Date Range by Day

RW9,

Thanks for answering my post.  No, you didn’t miss something really my question was really simple and I should have deleted the post.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 314 views
  • 1 like
  • 2 in conversation