"by" command and dropping observations

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

adrian_d
Posts: 44
Joined: Wed Jan 29, 2014 6:08 am

"by" command and dropping observations

Postby adrian_d » 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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: "by" command and dropping observations

Postby EViews Gareth » Wed Jan 29, 2014 9:04 am

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).


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests