Page 1 of 1

"by" command and dropping observations

Posted: Wed Jan 29, 2014 6:39 am
by adrian_d
Hello,

I've just transferred from Stata to Eviews and have some troubles with the commands that would do in Stata, but here I can't find them. Generally the problem is simple: I have an unstructured datafile, where there are more than one observation per one time unit (day). I want to make a daily datafile from it, so I firstly sum up other variables by days (with @sumsby command), but don't know how to leave in my workfile only first observations in each day. Basing on Stata, I would create a variable summing up or making IDs cumulatively by date and then drop rows if the sum>1. But how I can overcome this in Eviews?

Thanks

Re: "by" command and dropping observations

Posted: Wed Jan 29, 2014 9:04 am
by EViews Gareth
Create a new daily page. Copy the series over from the source page to the daily page, using a general match merge criteria (with date as the source and destination id, and sum as the contraction method).