"by" command and dropping observations
Posted: Wed Jan 29, 2014 6:39 am
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
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