Hi There, I am looking to create a PROC FREQ output to do a quick check on the number of variables for each day past a certain date. This issue is the date field in the source table is in date time format (e.g. 07AUG2006:16:25:00). I currently do this in PROC SQL with the following code: Proc SQL; Create table DateCheck as Select datepart(DateCreated)> format date9. as date, Count(*) as Volume From dataflow.datasource Where datepart(DateCreated)>='01JUL2018'd group by date; Quit; However, I would like to be able to do a PROC FREQ like this but it will not allow the datepart function: proc freq data=dataflow.datasource; tables datepart(DateCreated); where datepart(DateCreated GE intnx('month',&month.,0,'b'); format DateCreated date9.; run; Is this possible? Thanks, Jon
... View more