Nearly always, it will be a responses like: "It depends.", "your mileage may vary." and "What do you consider to be large?"
The SAS system is influenced not only by data but mostly by the operating environment (client, server and/or both).
However, some SAS features to consider exploiting are listed below:
- SAS view
- SAS index
- WHERE statement / clause, instead of IF.
- use or don't use COMPRESS= option for efficiency (data dependent).
- using PROC FORMAT for user-defined formatted display rather than un-normalized SAS data (where extra data variables are carried along unnecessarily).
Do take advantage of the SAS.COM support website where there are topic-related papers, technical reference material, as well as SAS-hosted documentation, such as a "companion" guide for each supported Operating System (OS) environment where SAS runs.
Suggest you get your "query" code defined, tested, then come back to the forum with a specific "performance" or efficiency/effectiveness issue / problem / question, for focused attention / feedback from the forum subscribers.
Scott Barry
SBBWorks, Inc.