Function Datepart

[fredbell]

Hi Reeza

If needed how can i convert it back to character so that i can say get the mean?

PROC SQL;
CREATE TABLE MEAN_Calls AS
SELECT date, MEAN(calls_handled)aS BPSMEAN
FROM mean1
group by date;
QUIT;

Above does not work, i'm assuming it is because the date is a number.

Fred This worked

proc MEANS NOPRINT data=mean1;
class date;
var calls_handled;
output out=new2 mean=calls_handled;
run;


Message was edited by: fredbell

[Reeza]

that should work. I need the log error to help debug. One suggestion would be to separate the as from the ) and possibly get the date as a 'date' rather than datetime (which is what i think you had it before).

PROC SQL;
CREATE TABLE MEAN_Calls AS
SELECT datepart(date) as grouped_date, avg(calls_handled) AS BPSMEAN
FROM mean1
group by datepart(date);
QUIT; Message was edited by: Reeza