1 / 25

What’s New in SAS

What’s New in SAS. Matt malczewski – communities manager. SAS 9.4. agenda. DS2 Language SAS Enterprise Guide 6.1 SAS Studio 3.1 SAS Analytics U. What’s new. DS2 language. SAS 9.4 Base SAS. New Programming language. DS2 - New SAS proprietary programming language

taini
Download Presentation

What’s New in SAS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What’s New in SAS Matt malczewski – communities manager

  2. SAS 9.4 agenda DS2 Language SAS Enterprise Guide 6.1 SAS Studio 3.1 SAS Analytics U What’s new

  3. DS2 language

  4. SAS 9.4Base SAS New Programming language DS2 - NewSAS proprietary programming language Object-based syntax – user-defined methods and packages ANSI SQL data type support Embedded FedSQL in the SET statement Runs anywhere – Base, In-Database (via SAS Code Accelerator), HPA (via HPDS2)

  5. DS2 overview DS2 is a new SAS proprietary programming language that is appropriate for advanced data manipulation and data modeling applications

  6. DS2 overview BIGINT BINARY(n) CHAR(n) DATE DOUBLE FLOAT(p) INTEGER NCHAR(n) The syntax of the DS2 language intersects with the SAS DATA step but also includes additional data types, ANSI SQL types, programming structure elements, and user-defined methods and packages NVARCHAR(n) REAL SMALLINT TIME(p) TIMESTAMP(p) TINYINT VARBINARY(n) VARCHAR(n)

  7. Basic ds2 syntax PROCDS2; data_null_; methodinit(); dclvarchar(20) foo; foo = '**> Starting'; put foo; end; methodrun(); set ds2_sas.banks; put_all_; end; methodterm(); dcl char(11) bar; bar = '**> I quit!'; put bar; end; enddata; run; quit; Initial processing Execution loop Final processing

  8. Ds2 Modern programming structure Packages User–defined: Create collections of re-usable, user-defined methods Pre-defined: • FCMP – Import PROC FCMP functions • Hash / Hash Iterator • Matrix – Do matrix math in DS2 • SQLStmnt – Execute data-driven SQL statements from within a DS2 program

  9. User-defined methods PROCDS2; data_null_; method c2f(double Tc) returnsdouble; /* Celsius to Farenheit */ return (((Tc*9)/5)+32); end; methodinit(); dcl double DegcDegF; do DegC=0to30by15; DegF=c2f(DegC); PUTDegC= DegF=; end; end; enddata; run; quit; Define method Call method

  10. procds2; data sales (overwrite=YES); keepCustomer_ID Total; methodrun(); set {select c.Customer_ID ,Total_Retail_Price from ds2_sas.order_fact f full join ds2_sas.customer_dim c on f.Customer_ID=c.Customer_ID order by 1}; bycustomer_id; iffirst.customer_idthen Total=0; Total+total_retail_price; iflast.customer_idthenoutput; end; enddata; run;quit; Embedded SQL in DS2 Returns SQL result set as input stream BY group processing on results

  11. Move the DS2 code to the MPP database SASIn-Database Code Accelerator SAS DS2 DATA DATA DATA DS2 Thread

  12. Ds2 Why use it? DS2 is beneficial in applications that need to use the extended data types can make use of packages and methods to re-use common functions or operations can utilize parallel processing (for computationally intense processes) require large data movement

  13. SAS enterprise Guide 6.1

  14. SAS 9.4Base SAS SAS enterprise guide 6.1 Support - SAS Enterprise Guide 6.1 is supported on SAS 9.4, 9.3, and 9.2. Improved programmer productivity - new Log Summary window, which lists all the errors, warnings, and notes that were generated when the program ran, as well as related line numbers and a sample of the affected code. Documentation– can add Sticky Notes for more information to a process flow or to specific objects in the process flow.

  15. Sas enterprise guide 6.1 Documentation Sticky notes

  16. Other new features Log summary

  17. SAS Studio 3.1

  18. SAS 9.4Base SAS SAS Studio 3.1 Write and run SAS code through a web browser Included with Base SAS 9.4 Access data files, libraries and existing programs Submit code from a variety of devices, IPAD, MAC, Windows desktop, Laptop SAS Studio processes the SAS code on a SAS server and returns results to the browser Functionality similar to Enterprise Guide: - Code generating tasks - Auto-complete for SAS procedures - Process Flows Tutorial - Getting Started with SAS Studio http://support.sas.com/training/tutorial/studio/get-started.html

  19. SAS 9.4Base SAS SAS Studio 3.1

  20. SAS Analytics U

  21. To learn more http://support.sas.com/learn/ap/index.html https://www.facebook.com/SASAnalyticsU

  22. SAS 9.4Base SAS Learn more Training - DS2 Programming: Essentials https://support.sas.com/edu/schedules.html?id=1798&ctry=US Papers- Parallel Data Preparation with the DS2 Programming Language (.pdf) http://support.sas.com/resources/papers/proceedings14/SAS329-2014.pdf Documentation- SAS® Enterprise Guide® 6.1 http://support.sas.com/software/products/guide/index.html Tutorial - Getting Started with SAS Studio http://support.sas.com/training/tutorial/studio/get-started.html

  23. Thank You!___________________________matt.malczewski@sas.com

More Related