Search results for query: *

Hi, How do I extract particular records in sas?For example, From the last observation, I want the preceeding 10 observations and no more. For example: Obs Name 1 a 2 e 3 l 4 gj 5 gd 6 td 7 sd 8 sg 9 s 10 sjkd 11 sjsk I just want the observations from...

Hi Klaz, Thank you very much for your help. Unfortunately it is not only a weekend problem. This is all data on stock trading and there are several days other than weekends when stocks don't trade (such as special holidays or after Sept 11 when trading was halted). I tried getting a list of...

Hi Chris, I tried the above code and unfortunately it didn't work. To give you a better sample: File A ID NUMBER DAY COUNT VALUESFORA 1 -2 10 1 -1 20 1 20020908 5 1 1 4 1 2...

Hi what I am trying to accomplish is this: File A ID Number Date Value 1 -2 .4792 1 -1 0.3791 1 20030906 0.31791 1 1 0.3191 1 2 0.3810 2 -2 0.3819 2 -1 0.31810 2...

Hi klaz, Thank you very very much for your help. However, there is one hitch, I cannot just sum the dates because there are days in between like weekends and holidays that this file does not count. And since it is a large data set for a large project, it would be difficult to get a lookup file...

If this doesn’t work, I can match this with another file: File A Name Date B -2 B -1 B 20030901 B 1 B 2 C -2 C -1 C 20040709 C 1 C 2 FILE B: Date Value 20030102 798392.892 20030103 79429.8020 20030104 74992183.79329 Now is...

Also I need to execute this in a loop. For example the file would be: Name Date B -2 B -1 B 20030901 B 1 B 2 C -2 C -1 C 20040709 C 1 C 2 Thanks.

Thanks so much Chris!

Hi, Is there any auto fill in date command in SAS?I have a file like this: Name Date B -2 B -1 B 20030901 B 1 B 2 Now the middle row has the date, and I need for SAS to give me the date for the previous dayS where there is -1 and -2 and for the next days where...

Hi, I have a text file in the following format 6387 Ret -2 1.0048 -1 0.0064 0 -1.3263 1 -1.73829 2 -0.63282 5679 Ret -2 -2.373 -1 0.3873 0 8.383 1 -7.38 2 0.373 So basically 6387 and 5679 are two different records..and...