SAS and all other SAS Institute Inc product

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

Presenter Nancy Rausch, Sr. Development Manager, SAS Institute Nancy Rausch is a Senior Manager at SAS Institute. Nancy has been involved for many years in the design and development of SAS’ data warehouse and data management products, working closely with customers and authoring a number of papers on SAS data management products and best practice design principals for data management solutions. She holds a Master of Science degree from Duke University in Computer Engineering where she specialized in Statistical Signal Processing, and Bachelor of Science degree in Electrical Engineering from Michigan Technological University. She is currently pursuing a Master of Science in Analytics from Capella University. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

What’s new in SAS Data Management Nancy Rausch SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

Themes 1. Connect 2. Transform 3. Govern 4. Discover SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

Connect SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

#SASGF … plus many more… SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

CAS Engine /*Assign a CAS engine libref. */ libname mycas cas; data mycas. cas_cars (promote=yes); set redshift. class; run; SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

Hadoop Hive Enhancements • Added support for truncate tables • Insert Overwrite support • Cross schema joins • JSON engine SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

#SASGF caslib mylib datasource= (… datatransfermode= <parallel, serial, auto, default>…) SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

#SASGF SAS Text Analytics SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

Transform SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

Data Integration Studio: Table Maintenance Transform • • Create Alter Drop Truncate Describe Pass-through Explicit pass-through Templates for various databases SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

session server; /* Start checking for existence of each input table */ exists 0=does. Table. Exist("DEMO_DATA", "id-1519737077561 -1531_CUSTOMERINFO_1_1"); if exists 0 == 0 then do; print "Table "||"DEMO_DATA"||"id-1519737077561 -1531_CUSTOMERINFO_1_1" || " does not exist. "; print "User. Error. Code: 100"; exit 1; end; print "Input table: "||"DEMO_DATA"||"id-1519737077561 -1531_CUSTOMERINFO_1_1"||" found. "; exists 1=does. Table. Exist("DEMO_DATA", "ZIPLATLONG"); if exists 1 == 0 then do; print "Table "||"DEMO_DATA"||"ZIPLATLONG" || " does not exist. "; print "User. Error. Code: 100"; exit 1; end; print "Input table: "||"DEMO_DATA"||"ZIPLATLONG"||" found. "; /* End checking for existence of each input table */ load. Action. Set "datastep"; run. Code result=r status=rc / code='/* BEGIN data step with the output table data */ data "id-1519737077561 -1531_CUSTOMERINFO_1_0" (caslib="DEMO_DATA" promote="no"); /* Set the input set */ set "id-1519737077561 -1531_CUSTOMERINFO_1_1" (caslib="DEMO_DATA" drop="customer"n drop="genderval"n ); /* END data step run */ run; '; if rc. status. Code != 0 then do; print "Error executing datastep"; exit 2; end; drop. Table. If. Exists("DEMO_DATA", "766 efd 9 c-394 d-4874 -9201 -1 ad 094 da 90 ff"); SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

Govern SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

Business Data Network • Snapshots: Historical Management of Vocabularies • CSV File import • Enhanced Lineage integration • Documented Application Programming Interface (API) SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

Discover SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

#SASGF Discover Data Lake Date Email Phone [PERCENTAGE] 2% Organization 20% Unknown 100% Address 3% Currency 10% Government ID [PERCENTAGE] Bank ID [PERCENTAGE] City [PERCENTAGE] Network Organization [PERCENTAGE] Postal Code [PERCENTAGE] State [PERCENTAGE] Person [PERCENTAGE] SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

Data Discovery SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

What can be discovered • • • CITY–STATE/PROVINCE– POSTAL CODE COUNTRY CURRENCY DATE/TIME DELIVERY ADDRESS E-MAIL FULL ADDRESS Various GOVERNMENT ID fields • • • GEOGRAPHICAL POINT IBAN INDIVIDUAL NETWORK ADDRESS ORGANIZATION PAYMENT CARD NUMBER PHONE POSTAL CODE SOCIAL SECURITY NUMBER STATE/PROVINCE URL SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

Example SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

#SASGF SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.

Want to know more? Come visit us on the Demo Floor! Watch the super demos! Join the discussion! Communities. sas. com/data-management SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies. #SASGF

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand product names are trademarks of their respective companies.