Date: Fri, 27 Jun 2008 06:09:17 -0700
Reply-To: fredybeach <vishaal.baulkaran@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: fredybeach <vishaal.baulkaran@GMAIL.COM>
Organization: http://groups.google.com
Subject: need a bit of help
Content-Type: text/plain; charset=ISO-8859-1
Sorry for not being clear earlier.
See sampe data below - I have more than 1000 firms.
First, I want to make sure that all the stock have atleast 18 months
of data. For example, google missing data (has only 16 mths) so I want
to screen out google.
Second, I want to make sure that I have uninterrupted data. For
example, apple is missing Nov. Dec. 2006 data. So I want to screen out
apple.
I am a new user and would appreciate some help.
DATE TICKER PERMNO RETX
20060131 MSFT 10107 0.076482
20060228 MSFT 10107 -0.045471
20060331 MSFT 10107 0.012653
20060428 MSFT 10107 -0.112459
20060531 MSFT 10107 -0.062112
20060630 MSFT 10107 0.028698
20060731 MSFT 10107 0.032618
20060831 MSFT 10107 0.068163
20060929 MSFT 10107 0.064202
20061031 MSFT 10107 0.049726
20061130 MSFT 10107 0.02264
20061229 MSFT 10107 0.01703
20070131 MSFT 10107 0.03349
20070228 MSFT 10107 -0.087168
20070330 MSFT 10107 -0.01065
20070430 MSFT 10107 0.074273
20070531 MSFT 10107 0.025053
20070629 MSFT 10107 -0.039756
20070731 MSFT 10107 -0.016288
20070831 MSFT 10107 -0.008969
20070928 MSFT 10107 0.025409
20071031 MSFT 10107 0.249491
20071130 MSFT 10107 -0.087205
20071231 MSFT 10107 0.059524
20060131 AAPL 14593 0.050355
20060228 AAPL 14593 -0.092968
20060331 AAPL 14593 -0.084246
20060428 AAPL 14593 0.12229
20060531 AAPL 14593 -0.150874
20060630 AAPL 14593 -0.041827
20060731 AAPL 14593 0.18666
20060831 AAPL 14593 -0.001619
20060929 AAPL 14593 0.134562
20061031 AAPL 14593 0.053261
20070131 AAPL 14593 0.01049
20070228 AAPL 14593 -0.013064
20070330 AAPL 14593 0.098097
20070430 AAPL 14593 0.074158
20070531 AAPL 14593 0.214339
20070629 AAPL 14593 0.007005
20070731 AAPL 14593 0.079646
20070831 AAPL 14593 0.051002
20070928 AAPL 14593 0.108247
20071031 AAPL 14593 0.237701
20071130 AAPL 14593 -0.040695
20071231 AAPL 14593 0.087038
20060131 CSCO 76076 0.084696
20060228 CSCO 76076 0.08993
20060331 CSCO 76076 0.070652
20060428 CSCO 76076 -0.033226
20060531 CSCO 76076 -0.060621
20060630 CSCO 76076 -0.007622
20060731 CSCO 76076 -0.084485
20060831 CSCO 76076 0.229866
20060929 CSCO 76076 0.04502
20061031 CSCO 76076 0.050044
20061130 CSCO 76076 0.115209
20061229 CSCO 76076 0.015608
20070131 CSCO 76076 -0.025979
20070228 CSCO 76076 -0.025545
20070330 CSCO 76076 -0.015806
20070430 CSCO 76076 0.047395
20070531 CSCO 76076 0.006731
20070629 CSCO 76076 0.034547
20070731 CSCO 76076 0.038061
20070831 CSCO 76076 0.104116
20070928 CSCO 76076 0.037904
20071031 CSCO 76076 -0.00211
20071130 CSCO 76076 -0.15245
20071231 CSCO 76076 -0.033908
20060131 YHOO 83435 -0.122639
20060228 YHOO 83435 -0.067345
20060331 YHOO 83435 0.006238
20060428 YHOO 83435 0.016119
20060531 YHOO 83435 -0.036303
20060630 YHOO 83435 0.044634
20060731 YHOO 83435 -0.177576
20060831 YHOO 83435 0.06227
20060929 YHOO 83435 -0.123136
20061031 YHOO 83435 0.04193
20061130 YHOO 83435 0.025437
20061229 YHOO 83435 -0.054424
20070131 YHOO 83435 0.108457
20070228 YHOO 83435 0.090074
20070330 YHOO 83435 0.013934
20070430 YHOO 83435 -0.103867
20070531 YHOO 83435 0.023538
20070629 YHOO 83435 -0.054704
20070731 YHOO 83435 -0.143015
20070831 YHOO 83435 -0.022366
20070928 YHOO 83435 0.180928
20071031 YHOO 83435 0.15861
20071130 YHOO 83435 -0.137942
20071231 YHOO 83435 -0.132413
20060131 GOOG 90319 0.042906
20060228 GOOG 90319 -0.161883
20060331 GOOG 90319 0.075506
20060428 GOOG 90319 0.071641
20060531 GOOG 90319 -0.110351
20060630 GOOG 90319 0.127777
20060731 GOOG 90319 -0.078053
20060831 GOOG 90319 -0.020874
20060929 GOOG 90319 0.061739
20061031 GOOG 90319 0.185345
20061130 GOOG 90319 0.017675
20061229 GOOG 90319 -0.050185
20070131 GOOG 90319 0.089081
20070228 GOOG 90319 -0.103789
20070330 GOOG 90319 0.019379
20070430 GOOG 90319 0.028855
