TOPICS The manner and speed in which information is hashed and indexed makes Teradata a valuable tool for satisfying time sensitive Congressional requests at the Centers for Medicare and Medicaid Services (CMS). Ordered Analytical Functions enable On-Line Analytical Processing (OLAP) requests containing ANSI SQL: 2003 window functions, which greatly enhance the functionality of the Structured Query Language (SQL). This paper will discuss how SAS 9.1 programming techniques can be imitated within the Teradata 12 environment using SAS\ACCESS ® passthough queries and the simulation of By-Group processing with dot notation. The methods discussed will help users make an easier transition from traditional SAS programming to a Massively Parallel Processing (MPP) Teradata platform running shared nothing architecture
To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.