Hi all, I need help. I have a dataset of accounts that have multiple trades. I want to: 1.  count number of trades each account has. 2. Determine if the account trades in a 'secured',  'unsecured' or 'combined'  industry.         PS: secured trades are filtered as IndustryCode= MB or VF.   My dataset looks like this: Acc_no   IndustryCode 283           MB 286           PL 286           IN 286           CE 286           NL 286           FL 287           VF 287           CL 287           NL   I want output like the following:   Acc_no    Num_Industries       Indicator 283              1                          'Secured' 286              5                          'Unsecured' 287              3                          'Combined' ... View more

good day all;   I would really appreciate it if someone can assist me. I have a payment file where one contract has multiple entries. A payment can be made and reverse. I'm struggling to put a code together in order for me to identify defaulters.   Sample Data: account number      Amount    Date                                          Type 92865                     $-200.00   24APR2018:00:00:00.000         REC  92865                     $200.00    24APR2018:00:00:00.000         REV_REC  92865                     $-200.00   19MAY2018:00:00:00.000        REC  92865                     $-177.20   10JUN2018:00:00:00.000         REC  92865                     $-400.00   08JUL2018:00:00:00.000         REC  92865                     $-200.00   05AUG2018:00:00:00.000        REC  92865                     $200.00    19SEP2018:00:00:00.000         REV_REC  92865                     $-200.00   19SEP2018:00:00:00.000         REC  92865                     $-200.00   18OCT2018:00:00:00.000         REC  100668                   $-150.98    25APR2018:00:00:00.000        REC 100668                   $-150.18    24MAY2018:00:00:00.000        REC 100668                   $-150.98    29JUN2018:00:00:00.000         REC 100668                   $-150.18    25JUL2006:00:00:00.000          REC 100668                   $-150.18    06AUG2005:00:00:00.000        REC 100668                   $-150.98    31SEP2009:00:00:00.000         REC 100668                   $-150.18    04OCT2018:00:00:00.000        REC 100668                   $150.18     04OCTG2018:00:00:00.000     REV_REC     Anticipated outcome is: Account number     Month   Default Flag 92865                    Apr       1 92865                    May      0 92865                   Jun        0 92865                   Jul         0 92865                   Aug       0 92865                   Sep       1 92865                   Oct        0   100668                  Apr      0 100668                  May     0 100668                 Jun       0 100668                 Jul        0 100668                 Aug      0 100668                 Sep      0 100668                 Oct       1   ... View more

good day,   May someone please assist me.   I have a dataset where I need to create subgroups, the problem though is that these groups overlap and its one variable that is in use. example if data is as follows: Acct number  ACC002CRT     Industry 1                         5              clothing 1                         3              cellular 1                         2              insurance 2                         1              loans 2                         0              insurance 3                         3              mortgage and bonds 4                         9              vehicle 4                       13              loans   now the subgroups that need to be created based on the data are:   if ACC_CRT >=12 then A01; if  6 <=ACC_CRT <12 then A02; if ACC_CRT >=9 then C01; if ACC_CRT =1 then F22; if ACC_CRT < 6 then B05; etc.   also I need to count the number of industries each account is in. e.g. 2 or more industries then C10;   An assistance to this will be highly appreciated.   ... View more