Hi, I have the following problem I have been struggling with. I have two data sets which I have merged. One is a set of historical pricing data and the other is the trading data for an individual. I'll start by describing the data: CUSIP - This is the stock id Date     - I have daily historical pricing data for each cusip (i.e. stock). Price    - This is the corresponding historical price for that date and stock Shares - indicates the number of shares that the trader purchases trandate - This is the date of the purchase and should mate the date subsample - This is an indicator variable that is 1 for all  days when date =trandate (i.e. this is when the trader traded)      cusip           date           price      shares      prices      trandate      subsample 1      222      1011985           5.15           .           .                .                          . 2      222      2011985           4.14           45           4.2           2011985        1 3      222      3011985            6.16           .           .                .                         . 4      222      4011985           20                .           .                .                         . 5      222      5011985           2.41           34           5.2           5011985         1 6      222      6011985           3.24           .                .                .                     . 7      222      7011985           5.25           .                .                .                     . 8      222      8011985           2.56           .                .                .                     . 9      222      9011985           2.25           .                .                .                     . 10     222      10011985           5.6           .                .                .                    . 11      333     1011985           3.52           .                .                .                    . 12      333      2011985           4.14           .                .                .                   . 13      333      3011985           7.23           .                .                .                   1 14      333      4011985           1.45           .                .                .                    . 15      333      5011985           5.63           .                .                .                    . 16      333      6011985           5.13           .                .                .                    . 17      333      7011985           5.25           23           5.42      7011985          1 18      333      8011985           5.12           .                 .                .                    . 19      333      9011985           2.34           .                  .                .                   . 20      333      10011985      7.65                .                .                .                   . 21      444        01011985             5.40          .                    .               .             . 22      444        02011985              6.40          .                    .               .             . I am trying to do the following things I want to create a new sub sample which remove all the data for a security when there is not a single trader transaction over the entire period (i.e. the last 4 columns never display any data) for that security. In the case of the data above this would mean keeping all the data except for the final two lines because the trader never traded security 444. Any help is greatly appreciated!!! ... View more

Hi, I have a large number of columns and rows. I want to delete a row of data if one specific variable is missing (FIRMID) which is a character variable I tried the following but it didn't seem to work data want;      set have;      if FIRMID = " " then delete;      run; Any help appreciated ... View more

Hi, I have a large number of columns and rows. I want to delete a row of data if one specific variable is missing (FIRMID) which is a numerical variable I tried the following but it didn't seem to work data want;      set have;      if FIRMID = . then delete;      run; Any help appreciated. ... View more

Hi I am trying to get a feel for my data and the number of unique observations I am wanting to count the number of firms (the variable is called cusip). count the number of firm names (the variable is called firms) Any help is appreciated ... View more

Hi, I would like to select data between two dates and then exclude certain firms within those dates. Dates are identified by TRANDATE (i.e. transaction date) Firm I.D is based of the variable SIC I tried to perform this in two steps because I wasn't sure how to do this in one. I keep unfortunately getting error msg's data subsamp1;   set table1;   if TRANDATE between '01jan1986'd and '31Dec2003'd then delete; run; data   subsamp2;   set subsamp1;   if 4900<= SIC <= 4999 or   6000<= SIC <= 6999 then delete; run; ... View more

Hi I have a data set and would like to remove certain firms: Firms are identified by the SIC variable. I would like to remove all firms between 4900-4999 and 6000-6999 How does the following code look? data  subsample2; set subsample1; if SIC between 4900 and 4999 or 6000 and 6999 then delete; run; ... View more