Date Range by Day

Accepted Solution Solved
Reply
Super Contributor
Posts: 465
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
Esteemed Advisor
Esteemed Advisor
Posts: 7,251

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
Esteemed Advisor
Esteemed Advisor
Posts: 7,251

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: 465

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
  • 264 views
  • 1 like
  • 2 in conversation