Procedures in Aster, DB2, Greenplum, Hadoop, HAWQ, Impala, Microsoft SQL Server, Netezza, Oracle, PostgreSQL, Redshift, SAP HANA, and Vertica

The following Base SAS procedures have been enhanced for in-database processing inside Aster, DB2, Greenplum, Hadoop, HAWQ, Impala, Microsoft SQL Server, Netezza, Oracle, PostgreSQL, Redshift, SAP HANA, and Vertica.
  • FREQ
  • RANK
    Note: In the fourth maintenance release of SAS 9.4, PROC RANK in-database processing is supported by Hadoop with Hive .13 and later.
  • REPORT
  • SORT
    Note: Only the NODUPKEY option of PROC SORT is supported with in-database processing.
    Note: In the fourth maintenance release of SAS 9.4, PROC SORT in-database processing is supported by Hadoop with Hive .13 and later.
  • SUMMARY/MEANS
  • TABULATE
  • TRANSPOSE
    Note: PROC TRANSPOSE in-database processing is supported only by Hadoop. Additional licensed products and configuration are required. For more information, see Running PROC TRANSPOSE inside the Database .
For more information about running a specific procedure inside the data source, see the documentation for that procedure.
Copyright © SAS Institute Inc. All Rights Reserved.