Date Range by Day

Accepted Solution Solved
Reply
Super Contributor
Posts: 494
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: 7,720

Re: Date Range by Day

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: 7,720

Re: Date Range by Day

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;
Super Contributor
Posts: 494

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.

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

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