FURTHER IMPROVEMENTS UNDER SAS 6.07

Seventeenth Annual SAS Users Group International Conference

Anne Soeder ; Glaxo Inc. ; RTP ; NC

PID  :  87631

来源: CEUR

【 摘 要 】

Attempting to JOIN a small SAS dataset with a large OB2table using Proc SQL can require large amounts of memoryand CPU time. This JOIN can be made more efficient witha macro which will soon be available in the SAS.SAM PLE.LIBRARY Further improvements can be realized withimproved SQL processing in SAS version 6.07 with the Passthrough feature. This paper will demonstrate how the useof one or both of these techniques will reduce up to seven