Almost every operation you are able to perform using SAS software can be achieved in many different ways, each with their own advantages and disadvantages. It is not always possible to predict the disadvantages, as a basic operation may be suitable in one circumstance, but may be totally inappropriate in another. Using SAS/ACCESS software and PROC SQL there are a wide variety of alternative methods, but, in general, only one is likely to give a solution and a fast response time. This paper explores these choices and gives an insight into how to determine the most efficient approach.
- Barclaycard SAS User Group, Northampton, UK – 28th July 1997