@Patrick wrote: The main advantage of temporary tables is basically that you don't have to drop the data (delete/truncate) once you're done with your job Yes, this is exactly the reason. The final data afterwards will be anyway stored in the same ORACLE, but moved to its final tables. Actually SAS is used just for retreiving data from different sources (csv, txt, ORACLE, SQL Server) at the same time, merge it and do with that some basic transformations (for which SAS is overqualified:-)). The code itself is split up into many different files, but put together I get 286 A4 pages. So the intention to move the intermediate steps to ORACLE was just kind of quick win (just by redirecting at the very begining of the script). Next steps will be anyway to rewrtite the whole script towards SQL (on ORALCE), but using SAS just as ETL tool (other ETL tools are not allowed unfort.).
... View more
