Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Running a Loop that Counts Observations
Okay, I havn't quite got there. Basically, i was really trying to simplify my task. I actually have 30 millions rows of data. What I can do is take out all the trades, so we can forget about QUOTES. For every new trade, I need to count the number of trades that occured in the previous half an...- marksnape
- Post #4
- Forum: SAS Institute, Inc. solutions
-
Running a Loop that Counts Observations
I think I can adapt the second code to acheive what I want. Thanks Klaz- marksnape
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Running a Loop that Counts Observations
Hi, I need to code a loop, my data looks (simplified) like this: Obs Type Time 1 QUOTE 12:01:00 2 TRADE 12:02:00 3 QUOTE 12:03:00 4 QUOTE 12:04:00 5 QUOTE 12:06:00 6 TRADE 12:18:00 7 QUOTE 12:23:00 8 TRADE 12:28:00 9 QUOTE 12:29:00 10 QUOTE 12:30:00 11 TRADE 12:32:00 12 QUOTE 12:36:00 13 TRADE...- marksnape
- Thread
- Replies: 5
- Forum: SAS Institute, Inc. solutions
-
Removing Milliseconds in SAS
Cheers. A mixture of the two worked a treat for my data.- marksnape
- Post #4
- Forum: SAS Institute, Inc. solutions
-
Removing Milliseconds in SAS
Hi, I have a time series of data with time values to the nearest millisecond (eg. 08:04:15.137). How can I alter this so it is only recorded to the nearest second? i.e. 08:04:15 Alternatively, I have data with multiple records within one second, for example, with x and time fields: x time 1...- marksnape
- Thread
- Replies: 3
- Forum: SAS Institute, Inc. solutions
