sas update group... · 2016. 3. 11. · an introduction to ds2 shaun kaufmann farm credit canada ....

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d .

SAS UPDATE

JUNE, 2013


SAS GLOBAL FORUM

2013 THE AFTERMATH

• http://support.sas.com/resources/papers/proceedings13/

http://support.sas.com/resources/papers/proceedings13/http://support.sas.com/resources/papers/proceedings13/


SAS GLOBAL FORUM

2013 THE AFTERMATH

• http://www.lexjansen.com/

http://www.lexjansen.com/http://www.lexjansen.com/


SAS GLOBAL FORUM

2013 … ON DEMAND!


SAS GLOBAL FORUM

2014 THINKING AHEAD


SAS 9.4 HIGHLIGHTS

• 64-bit OS support

• High Performance Analytics suite of procedures

• Leverage multi-core processing on a single server

• ODS improvements

• Layout (output control)

• RWI – create/manipulate ODS objects in a data step

• New destinations: EPUB, POWERPOINT, HTML

• Improvements with SAS/GRAPH and SG Procedures


CLOUD!

• Cloud deployment (public & private) for business analytics

• Vmware & Amazon

• SAS Virtual Applications (SAS vApps)

• Prepackaged, multi-system virtual appliances

• SAS App Central

• A role-based web portal interface for administration of cloud-based SAS

environments

• SAS App Engine

• assemble and deploy SAS vApps and maintain deployed SAS vApp environments

• SAS App Works

• SAS cloud platform that supports development, sharing and collaboration between

development teams


DS2

• New proprietary programming language for advanced data

manipulation

• Included with Base SAS in 9.4

• Very similar to DATA Step, however, based on object oriented

concepts

• Uses objects (like hashes and threads) by setting their properties and

accessing their methods with DOT notation

• Runs out of:

•Base SAS, SAS High Performance Grid, In-database (SAS In-Database Code

Accelerator), High-Performance Analytics Server, SAS In-Memory Analytics


DS2

• Shared features include…

•SAS statements such as SET, BY, RETAIN, PUT, OUTPUT, DO, IF-

THEN/ELSE, and others

•implicit loop of the SET statement

•implicit declaration of global variables

•ability to call SAS functions and formats


DS2

• DS2 extends beyond the DATA step by…

• enabling SQL in the SET statement

• In-database execution

• supporting new data types such as INTEGER and VARCHAR

• adding user defined methods and packages

• providing variable Scoping

• enabling parallel execution of entire programs through threading


DS2 WHAT DOES IT LOOK LIKE?

data new;

retain min;

keep min;

if _n_=1 then min=9999;

set sasdata.class end=last;

if weight


DS2 WHAT DOES IT LOOK LIKE?

DS2 Code proc ds2;

data;

dcl double min;

Retain min; keep min;

method init();

min=9999;

end;

method run();

set sasdata.class;

if weight


DS2 MOST BENEFIT

•In processes that currently require large data movement

•Complex processes that could benefit from structured code

•Need to maintain consistency with the data types in a source database

AN INTRODUCTION TO DS2

Shaun Kaufmann

Farm Credit Canada

http://www.sas.com/offices/NA/canada/downloads/UserGroups/Regina-May2013/Kaufmann-DS2.pdfhttp://www.sas.com/offices/NA/canada/downloads/UserGroups/Regina-May2013/Kaufmann-DS2.pdf


OTHER UPCOMING

MEETINGS

• September 13th – TASS – statistics-heavy meeting (Rick Wicklin)..

• October 16th – Toronto Data Mining Forum

• October 25th –GHSUG (Burlington)

• November 15th – Health User G1[[proup

• December 13th - TASS

Copyr i g ht © 2012, SAS Ins t i tu t e Inc . A l l r ights reser ve d . www.SAS.com

MATT MALCZEWSKI

COMMUNITIES MANAGER

[email protected]

416-307-5000
http://www.sas.com/

sas update group... · 2016. 3. 11. · an introduction to ds2 shaun kaufmann farm credit canada ....

Documents