Hi   Typically there's a lead generation listing for marketing campaigns, let's say 10000 customers of marketing lead, each with different grouping.  Let's say 5000 customers with Group A, 2000 records with Group B and 3000 records with Group C   Have custID                group ABC123                    A DEF456                    A GHI789                     C JKL101                      A MNO112                   B F000131                   B G000415                   C ...                   Each of the group has its own group of staffs to be equally assigned to for telemarketing For example   staff                    group John                          A Paul                          A Sartre                        A Richard                     B Olsen                        B Lykke                        B Chuck                        C Norris                        C     Is there any function that allows me to equally assign the 10,000 customers to the list of staff by their group? Want table is as below   custID                group   staff ABC123                    A   Jean DEF456                    A    Paul GHI789                     C   Chuck JKL101                      A  Sartre MNO112                   B   Richard F000131                   B   Olsen G000415                   C Norris IJUIJ122                    A Jean YHU1232                   A Paul ....                    Thanks! ... View more

Hi,   Librefs are successfully assigned, but don't appear in the library section   ... View more

Hi,   I routinely have to send a proc freq result in my email as a report.   The flow is like this: 1. Extract data 2. Do some manipulation 3. Get the proc freq 4. Screenshot proc freq result and paste in the Outlook email 5. Send email   1-3 are already automated. But I still need to manually screenshot it and send the email on a daily basis.   What I wish to do is to fully automate this, if a scheduler is too advance, maybe at least I want to automate 4 and 5. Any tips and advice on how to do so? ... View more

www.bportugal.pt/PAS/en/help/image/decompTree.gif   Example is as above.   Often times proc freq with multiple variables become illisible.   Is there any way to recreate something as above? ... View more