Data Management topics at SAS Global Forum 2017

[AnnaBrown]

It's great to see all the sessions you all are interested in a SAS Global Forum 2017! I'd like to add a several handpicked sessions that speak to topics a few active community members identified as important on the Data Management Community. Here's a synapsis of that discussion.

DarthPathos expressed interest in all topics using Base SAS, including how to create a data dictionary for an SQL server database and ways to handle missing values for different types of datasets.

Below are a few related SAS Global Forum 2017 events. Note that the Super Demo schedule is TBD and that the actual papers will be available on the below links following the conference.

• Super Demo topic: Managing the Data Dictionary and Business Glossary using SAS® Business Data Network
• Paper: Automatically Map CDASH Data to the Study Data Tabulation Model (SDTM) Structure
• Paper: Document and Enhance SAS® Code, Data Sets, and Catalogs with SAS Functions, Macros, and Metadata
• Paper: Health-Care Data Sharing and Innovative Analytic Development in Distributed Data Networks 

SASKiwi requested info on ways to encrypt in-flight data between external RDMSs and SAS. Here’s a pertinent session:

•  Paper: Transport Layer Security (TLS) Configuration for SAS® 9.4 and SAS® Viya™ Components Made Easy

He also expressed interest in connecting to external databases using connection strings to decrease the need to configure outside of SAS. Related resources include:

• Paper: SAS® Views for Implicit, In-Database Teradata Queries on One or More Tables
• Recent SAS Communities article by Jeff Bailey: A quick guide to connecting to Oracle from SAS

And for SASKiwi’s suggestion for techniques to improve the reading and writing performance of data between SAS and external databases, consider these events:

• Paper: PROC DS2: What's in It for You?
• Super Demo: Exploring SAS® Embedded Process Technologies on Hadoop

LinusH added several ideas here as well, including many questions about SAS Viya, such as what and how SAS Data Management products will be implemented into SAS Viya. Various events to check out here:

• “Emerging Technologies” session, time/link TBD: The Power of Suggestion: Prepare Data Faster on SAS Viya and Hadoop
• Super Demo: Loading Data into Cloud Analytics Server on SAS Viya
• Super Demo: The Data Life Cycle between SAS Viya and a Remote Hadoop Cluster
• Paper: Introduction to SAS® Data Connectors and SAS® Data Connect Accelerators on SAS® Viya
• Paper: The Architecture of the SAS® Cloud Analytic Services in SAS® Viya
• The roundup of the latest SAS Data Management release notes speaks to some of this too.

For his question on mapping tools, don’t miss the session, What's New in SAS® Data Management, by SAS Data Management Sr. Manager, Software Development Nancy Rausch.

LinusH also asked about plans to integrate more attributes through SAS/ACCESS, and there is a breadth of SAS/ACCESS sessions to choose from in this regard.

Lastly, he hit on a topic I know you all know and love: SAS and Hadoop integration. It would be great, LinusH says, to see a comparison of data storage options (e.g., Hive, SPDE, SPD Server, SASHDAT, etc.). Some related sessions:

• (Again) “Emerging Technologies” session, time/link TBD: The Power of Suggestion: Prepare Data Faster on SAS Viya and Hadoop
• Paper: Ten Tips to Unlock the Power of Hadoop with SAS®
• Paper: From Source to Target: Hadoop Capabilities of SAS® Data Integration Studio
• Paper: Understanding SAS® Embedded Process with Hadoop Security
• Super Demo: The Data Life Cycle between SAS Viya and a Remote Hadoop Cluster
• Super Demo: SAS® Data Loader for Hadoop Goes Enterprise

[louisehadden]

I'm glad to see my e-poster listed here in the suggestions!

I also highly recommend a preconference tutorial "Dimensions of Software Quality: Introducing the ISO Software Product Quality Model to SAS® Practitioners", which is based on the book "SAS Data Analytic Development: Dimensions of Software Quality" by Troy Hughes.  Although it is advertised as a "Software Quality" course, there are many tools discussed that support robust data management.  I have gotten some valuable tips.

Looking forward to all the intellectual stimulation coming up at SGF plus the awesome kickback party!

[TBarker]

Will there be any sessions related to using SAS with SAP HANA?

[AnnaBrown]

Hi TBarker,

No, there aren't any sessions on using SAS with SAP HANA. But please stop by the SAS/ACCESS booth in the Quad area at SAS Global Forum to talk to the SAS Data Management team (Ron Agresta, Jeff Bailey, Tatyana Petrova and others) about how the two work together. 

Best,

Anna

[TBarker]

Great, thank you, Anna!