I'm trying to generate a summary table consisting of number of employees involved in tasks at certain hour ranges. But when creating the table, an employee that made a task twice in the hour range gets counted double.                                                                       January                                   Sunday     Monday      Tuesday     Wednesday     Thursday     Friday     Saturday      8:00-8:59          8               17               20               9                         11          23          47      9:00-9:59 10:00-10:59 And the correct count is                 6                12               16               4                         8             21          42 Using EG, how it is possible to get a non repeating count of IDEmployee? Thanks in advance César ... View more

I'm an EG user and i'm having trouble generating two recoded columns. The first aim is to identify the first big delay on life payments, based on that tipping point i want to identify by date the last purchase made before that event. These are the key variables If the delay is greater than 60 days, it is identify as the first big delay. Next, i take that payment date and identify the last purchase on SAS table 2 SAS Table 1 idclient                                                  payment date  DaysofDelay 436968 31MAR2011           70             07MAR2011         -24          436968 31MAY2011           139.83      20JUN2011           20          436968 15JUL2011           45.31         11SEP2011           58          436968 30APR2011           112           30APR2011           0          436968 15FEB2011           70             07MAR2011           20          436968 15MAY2011           112          15MAY2011             0          436968 30JUN2011           172.22      11SEP2011           73          First big delay 436968 15AUG2011           45.31       11SEP2011           27          436968 28FEB2011           104.8        07MAR2011           7          436968 30SEP2011           0.21          30SEP2011           0          436968 15APR2011           169.14      16APR2011           1          436968 15MAR2011           70             07MAR2011          -8          436968 15JUN2011           145.87      11SEP2011           88          436968 31JUL2011           45.31         11SEP2011           42          436968 31JAN2011           70              31JAN2011           0          437125 15JUN2011           277.52       08AUG2011           54          437125 15JUL2011           120.54        20AUG2011           36          437125 30APR2011           235.81       16JUN2011           47          437125 30JUN2011           318.9         20AUG2011           51          437125 15FEB2011           75              27FEB2011           12          437125 15MAR2011           75             21MAR2011           6          437125 31AUG2011           0.99          31AUG2011           0          437125 31JAN2011           75              27FEB2011           27          437125 31MAY2011          314.23      08AUG2011           69          437125 28FEB2011           75             27FEB2011           -1          437125 15MAY2011           275.01     16JUN2011           32          437125 15APR2011           185           16APR2011           1          437839 15MAY2011           75             17MAY2011           2          437839 31MAY2011           75             01JUN2011           1          437839 15APR2011           75             14APR2011           -1          437839 30APR2011           75             02MAY2011           2          437839 15JUN2011           98.9          07SEP2011           84          437839 30SEP2011           0.78          30SEP2011           0          437839 15AUG2011           26.08        07SEP2011           23          437839 30JUN2011           113.08      07SEP2011           69          437839 31JUL2011           26.08         07SEP2011           38          437839 15JUL2011           26.08         07SEP2011           54          SAS Table 1                                                                                                   idclient   purchasedate purchase          436968 09JAN2011      $240               436968 31JAN2011      .                    436968 07MAR2011     .                    436968 22MAR2011      $425          Last purchase 436968 16APR2011      .               436968 30APR2011      .               436968 15MAY2011     .               436968 20JUN2011      .               436968 11SEP2011      .               437125 27FEB2011      .               437125 21MAR2011      $745          437125 21MAR2011      .               437125 21MAR2011      .               437125 16APR2011      .               437125 16JUN2011      .               437125 08AUG2011     .               437125 20AUG2011      .               How do i make this work on EG? Thanks ... View more