Repeated dates

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

lucaski
Posts: 17
Joined: Thu Dec 16, 2010 8:19 am

Repeated dates

Postby lucaski » Wed Jan 12, 2011 9:44 pm

Hello, I'm working with a date series that has a lot of repeat dates and I need to get rid of then, how I can do that?

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

Re: Repeated dates

Postby EViews Gareth » Wed Jan 12, 2011 9:49 pm

Assuming that your date series is called "date", and the workfile is sorted by that series, then you can do Proc->Contract Current Page, and then enter "if date<>date(-1)" as the sample to keep.

lucaski
Posts: 17
Joined: Thu Dec 16, 2010 8:19 am

Re: Repeated dates

Postby lucaski » Wed Jan 12, 2011 10:32 pm

Oh i'm sorry, my series is a simple time series, it is not the data of my workfile, how can I get hid of the reapeated observations.

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

Re: Repeated dates

Postby EViews Gareth » Wed Jan 12, 2011 10:36 pm

I don't follow what you're saying.

You have some series that identifies observations. It takes on identical values for some observations. Sort by that series, then contract the page using a sample "if series<>series(-1)" where series is the name of the series you have that contains IDs.

lucaski
Posts: 17
Joined: Thu Dec 16, 2010 8:19 am

Re: Repeated dates

Postby lucaski » Wed Jan 12, 2011 10:43 pm

The series that has the repeated observations don't identifies my observations, my workfile is undated/unstructured. I tried to go to proc -> contract, but since my series is undated i'm unable to change my series called date from this option.

lucaski
Posts: 17
Joined: Thu Dec 16, 2010 8:19 am

Re: Repeated dates

Postby lucaski » Wed Jan 12, 2011 10:46 pm

I'm sorry, you are right, i was doing something wrong here, thank you.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 1 guest