Hi, I had a problem with writing the sas code in stored process. Value IN (&integermultiplevalueprompt); Is that true? And why it takes only the first variable and not all the integer list. Regards
... View more
Hello xia keshan and thank you for your answer, but what I need in my output table is 100 unique client id's this method displayed the same id many times with different dates.
... View more
Thank you but maybe my question was not very clear, the data is as follows: Client id date amount 10001 20141215 50 10002 20141215 30 10003 20141215 90 10001 20141216 70 10002 20141216 80 10003 20141216 5 10003 20141217 100 So if I have to choose 2 between these 3 clients I would be choosing 10001 and 10002, now consider this situation but with 100000 clients
... View more
I'm launching a marketing campaign in which I grant every client that reached a transaction sum of 100$ on his credit card a free gift card, The problem is that I need to choose the first 100 clients that reached this threshold, my data table include: - client id - transaction date - transaction amount Thank you in advance
... View more
I have a data table that consists of customers ID's and their telephone numbers in the following manner: Customer ID telephone number 5550 9613456789 5550 9613657894 6758 9611567854 Which function enables me to have the following format : Customer ID telephone number 1 telephone number 2 5550 9613456789 9613657894 6758 9611567854 . Thank you in advance for all your help
... View more