Page 1 of 1
Repeated dates
Posted: Wed Jan 12, 2011 9:44 pm
by lucaski
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?
Re: Repeated dates
Posted: Wed Jan 12, 2011 9:49 pm
by EViews Gareth
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.
Re: Repeated dates
Posted: Wed Jan 12, 2011 10:32 pm
by lucaski
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.
Re: Repeated dates
Posted: Wed Jan 12, 2011 10:36 pm
by EViews Gareth
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.
Re: Repeated dates
Posted: Wed Jan 12, 2011 10:43 pm
by lucaski
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.
Re: Repeated dates
Posted: Wed Jan 12, 2011 10:46 pm
by lucaski
I'm sorry, you are right, i was doing something wrong here, thank you.