Hi,
I currently have a data set with over 100,000 contract ids. I would like to filter by contract id to see where these contract ids appear in my time series data. Eventually I would like to compute the average time between when a certain contract id is used again. I tried using the tabulate command but got the too many values error. Is there a way to see the frequency of my contract ids as well as the date where they are taking place?
Thank You,
Robert
I currently have a data set with over 100,000 contract ids. I would like to filter by contract id to see where these contract ids appear in my time series data. Eventually I would like to compute the average time between when a certain contract id is used again. I tried using the tabulate command but got the too many values error. Is there a way to see the frequency of my contract ids as well as the date where they are taking place?
Thank You,
Robert