EViews.com

Posted: **Wed Feb 19, 2014 5:04 am**

Hello,
I have an unstructured/undated workfile and there I have a series containing intraday date (not unique, there are rows with the same date). How can I create from this a series containg daily, not intraday, date? I tried things such as using series daily_date = @makedate(intraday_date, "ddmmyyyy") but it doesn't work. Please help! :-)

adrian

Posted: **Wed Feb 19, 2014 9:02 am**

Post your workfile.

Posted: **Thu Feb 20, 2014 1:28 am**

Post your workfile.

Ok, take a look please. The aim is to have daily data with sum of total_conversions series per day.

Posted: **Thu Feb 20, 2014 9:19 am**

Something like:

Code: Select all


series date = @datefloor(activity_date_time, "DD")
pagecreate(page=daily) d7 2014/01/01 2014/02/28
series date = @date
copy(c=s) p2c\total_conversions daily\* @src date @dest date

Posted: **Fri Feb 21, 2014 2:36 am**

Great idea with @datefloor, thank you! :)

EViews.com

Date conversion within unstructured workfiles

Date conversion within unstructured workfiles

Re: Date conversion within unstructured workfiles

Re: Date conversion within unstructured workfiles

Re: Date conversion within unstructured workfiles

Re: Date conversion within unstructured workfiles