SAS Data Loader 2.4 includes new directives to help you work more efficiently: Chain directives- runs two or more saved directives in series or in parallel. One chain directive can contain another chain directive. A serial chain can execute a parallel chain, and a parallel chain can execute a serial chain. An individual directive can appear more than once in a serial directive. Results can be viewed for each directive in a chain as soon as those results become available. Cluster-Survive Data directive - uses rules to create clusters of similar rows. Additional rules can be used to construct a survivor row that replaces the cluster of rows in the target. The survivor row combines the best values in the cluster. This directive requires the Apache Spark run-time environment. Match-Merge Data directive - combines columns from multiple source tables into a single target table. You can also merge data in specified columns when rows match in two or more source tables. Columns can match across numeric or character data types. Run a Hadoop SQL Program directive - replaces the former directive Run a Hive Program. The new directive can use either Impala SQL or HiveQL. In the directive, a Resources box lists the functions that are available in the selected SQL environment. Selecting a function displays syntax help. A click moves the selected function into the SQL program.  See the SAS Data Loader 2.4 for Hadoop: User's Guide for additional information and examples. ... View more

Starting 1August2015, a new release of SAS Data Loader 2.3 for Hadoop is available.   See the What’s New documentation for more information about these software enhancements. Migration Support for SAS Data Loader 2.2 New Support for Importing Delimited Files into Hadoop Enhanced Support for SAS LASR Analytic Server Profile Enhancements New Features for Data Quality Analysis Usability Enhancements Enhanced Support for Hadoop, including support for MapR Enhanced Support for Apache Hive New Support for Active Directory (LDAP) Authentication Documentation changes too, including:  Updated System Requirements: System Requirements:  SAS® Data Loader 2.3 for Hadoop (PDF). The content that was formerly in the SAS Data Loader for Hadoop: Administrator's Guide is now in the “Administrator’s Guide for SAS Data Loader for Hadoop” section of the SAS In-Database Products: Administrator's Guide. ... View more

SAS® Data Loader 2.3 for Hadoop and its accompanying offering, SAS® In-Database Technologies for Hadoop, were released in July 2015. Previously, the system requirements were available in the SAS Data Loader documentation. In the current SAS Data Loader release, the complete system requirements are available from the Support site, System Requirements, under SAS 9.4 (left nav bar):           System Requirements:  SAS® Data Loader 2.3 for Hadoop (PDF). Please review the system requirements carefully before you deploy this offering. ... View more

SAS Data Loader for Hadoop (Trial Edition) supports HDP 2.2 on Hortonworks Sandbox but not HDP 2.3 and later. Please download the HDP 2.2 version for your Trial. ... View more

There are multiple ways to install a SAS Quality Knowledge Base for use with SAS Data Loader for Hadoop. See "SAS Quality Knowledge Base (QKB)" in the SAS 9.4 In-Database Products: Administrator's Guide for more information.   Run the SAS Deployment Wizard (SDW). In the Select Products to Install dialog box, select the check box for SAS Quality Knowledge Base for your order. This installs the SAS QKB for Contact Information. Note: The SDW option applies only to the SAS QKB for Contact Information. For step-by-step guidance to install a QKB using the SAS Deployment Wizard, see the SAS Quality Knowledge Base for Contact Information: Installation and Configuration Guide on the SAS Documentation site.   Download a QKB from the SAS Downloads site. This option can be used for either the SAS QKB for Product Data or the SAS QKB for Contact Information. Select a QKB and then follow the installation instructions in the Readme file for your operating environment. To open the Readme file, you must have a SAS profile. When prompted, you can log on or create a new profile.   Copy a QKB that you already use with other SAS software in your enterprise.   After your initial deployment, periodically update the QKB in your Hadoop cluster to make sure that you are using the latest QKB updates provided by SAS. For more information, see “Updating and Customizing the SAS Quality Knowledge Base” in SAS 9.4 In-Database Products: Administrator's Guide. ... View more

SAS Data Loader for Hadoop (Trial Edition) supports Cloudera QuickStart VM for CDH 5.3  but not CDH 5.4 at this time. Please download the 5.3 version for your Trial. ... View more

Starting with the second maintenance release of SAS 9.4, the SAS PC Files Server now has its own documentation, SAS 9.4 PC Files Server: Installation and Configuration Guide, which is located on the SAS/ACCESS Documentation page.   This guide describes how to install, configure, use, and administer SAS PC Files Server in SAS 9.4. The guide includes step-by-step instructions and examples. SAS PC Files Server requires a license for SAS/ACCESS Interface to PC Files.     This guide also includes, replaces, and enhances content from a number of SAS Notes, including   Installation Note 54413 Usage note 43802 Usage Note 47237 ... View more

As of 7May2015, an updated version of the SAS Data Loader Trial software is available.   All SAS Quality Knowledge Base (QKB) locales are now supported. You can use a locale from the QKB for Contact Information.  A QKB is a collection of files that store data and logic that define data management operations, such as data cleansing. A QKB includes language- and country-specific locales that have differing formats for names, addresses, cities, and so on. The default QKB locale for SAS Data Loader for Hadoop is “English, United States” (ENUSA).   The updated Trial version of SAS Data Loader is translated from English into other languages, including German, Spanish, French, Italian, Japanese, Korean, Polish, Russian, and Chinese (Simplified, Traditional).   SAS Data Loader for Hadoop (Trial Edition) and the SAS Information Center use the language that you set in the web browser. For the Cleanse Data in Hadoop directive, all locales from the QKB for Contact Information are available and you can choose which one you want to use. This choice is independent from the language you have set in the web browser.   See the sas.com page for the latest download of SAS Data Loader for Hadoop - Trial.  ... View more

SAS MDM data jobs and real-time services use a Java node to interact with the SAS Data Remediation web service API. Due to enhancements made to this web service API in the 2.1, 1st maintenance release, SAS MDM 4.1 (1st maintenance) customers need to apply a patch to DataFlux Data Management Studio and DataFlux Data Management Server. The patch delivers an updated Java file that can communicate with the new SAS Data Remediation web service API.  See SAS Note 52345 for details. ... View more

Have you looked recently at the documentation for SAS Quality Knowledge Bases on the Documentation site?   See SAS Quality Knowledge Base for QKB installation and configuration guides. For SAS QKB for Contact Information 25 (and later), the product's Help is now available in HTML on the Documentation page as well. Check out these new resources. ... View more

The following note applies to SAS Data Loader 2.2 for Hadoop and to SAS Data Loader for Hadoop (Trial Edition). Some SAS Data Loader directives use a SAS Server (SAS Workspace Server) to read or write tables. By default, the character columns for the input tables to such directives are expanded to 32K in length.  Most columns do not need to be this long, and this setting can negatively impact your performance.   For best performance, we recommend that you reduce the default length of the character columns for these input tables. Specify a value, such as 1024, that is short enough to help performance but long enough to avoid truncating the data in character columns. See the User’s Guide for more information: Changing the Default Maximum Length for SAS Character Columns ... View more