Hi, I'm trying to wrap my head around how to compute buys and sells by a mutual fund in a particular quarter. My data looks like this:    Date     Fund        Stock          Shares-held Jun-90 Fund A      Apple              5000                              Microsoft         5000 Sep-90 Fund A      Apple             6000                              Microsoft        4000                              Oracle            2000 Dec-90 Fund A      Apple            6000                               Oracle           2000                              Facebook       2000   I'm in need of an output data set something like this buy/Sell                  Change in shares Jun-90                   Apple 5000                               Microsoft 5000 Sep-90                  Apple 1000                               Microsoft -1000                               Oracle 2000 Dec-90                  Microsoft -4000                             Facebook 2000 I tried using some combinations of sorting, if statements and lag statements and cannot seem to get all the values I want.    Thank you -R ... View more

Hi, I am having trouble spliiting some unstructured data. My data looks like this ColA                                                                             ColB Fund1                        [2011-07-01--2013-07-31] Richard Glass Fund2                [2011-06-30--2015-05-15] William M. Noonan; [2011-06-30--2015-05-15] Philip A. Noonan ;                                                                      [2011-06-30--2015-05-15] David Canal Fund3                [2012-01-03--] Robert E. Hall; [2012-01-03--] Keith A. Lee; [2012-01-03--] Kempton M. Ingersol; [2012-01-03--2015-                              03-01] Amy Y. Zhang; [2013-12-31--] Damien Davis; [2014-12-31--] Andrew J. Fones I want my data to look like this   ColA             Entry1          Exit1          Manager1                Entry2        Exit2        Manager2           Entry3,exit3, Manager3 and so on Fund1          20110701     20130731  Richard Glass          Fund2         20110630     20150515   William M. Noonan  20110630 20150515  Phili A.Noonan   Currently I am using a scan function to split using delimiters,but it is taking too long I am trying something like this, but i feel like I need to repeat this code too much and it is not optimal. data split; set ms_fundmanager; length v1-v10 $100.; array v(10) $; do i = 1 to dim(v); v[i]=scan(manager_history,i,';','M'); end; run; data split1; set split; length av1-av2 $100.; array av(2) $; do i = 1 to dim(av); av[i]=scan(v1,i,']','M'); end; rename av2 = manager1; run; ... View more