topic Re: change DATETIME var to DATE in SAS Enterprise Guide

change DATETIME var to DATE

deleted_user — Thu, 29 Jun 2006 21:32:21 GMT

Hi,
i making web log analysis and i want to sort page views per date. As we know, the date in weblog files has this format: 02JUN2006:00:00:00. I tried to create a new variable with only the day or date (eg. 02jun or 02jun2006) by truncating or new format, but it didnt work!!

thanks for your help

Jean-Sebastien

Re: change DATETIME var to DATE

deleted_user — Fri, 30 Jun 2006 13:18:00 GMT

Jean-Sebastien,

You can apply one of the date formats in you data or sort step:

data _null_;
d='02jun2006:00:01:00'dt;
put d= datetime. / d= datetime9. / d= dtdate9.;
run;

Re: change DATETIME var to DATE

deleted_user — Fri, 30 Jun 2006 16:01:36 GMT

THANKS nori, it worked!

Re: change DATETIME var to DATE

deleted_user — Fri, 30 Jun 2006 17:09:37 GMT

Another option is the datepart function which will return a date sequence.

data _null_;

datetime_var = '07jun2006:01:05:06'dt;

date_var = datepart(datetime_var);

format datetime_var datetime20. date_var date9.;

put _all_;

run;