When using SAS to extract data from a live Oracle database, it is important to write accurate and efficient code that will not hamper the performance of other users. The best way to do this is to have Oracle perform the initial data query before bringing the selected records to SAS. To accomplish this, the SAS user must write SQL code that Oracle will understand and compute properly. SAS has included enhancements in Version 9.2, such as the so-called "Un-Put Technologies" that make this easier. This paper will teach SAS users, including those without access to Version 9.2, how to use PROC SQL efficiently and effectively with Oracle and other non-SAS databases.
conference:
Paper Type:
Paper
