what’s new in - sas institute€¦ · •author and run sas viya jobs (think stored process) •...

www.sas.com/fans

What’s New in • SAS® Enterprise Guide 8.2 • SAS® Studio 5.2

daniel@swe.sas.com

AGENDA

• SAS® Enterprise Guide or SAS® Studio – which one should I choose?

• What’s New in SAS® Enterprise Guide 8.2

• What’s New in SAS® Studio 5.2

• Demo

SAS Enterprise Guide and SAS StudioWhich one should I choose?

SAS Studio

SAS Enterprise Guide

Which one can I use?

SAS 9 or SAS 9+Viya

EG 7/8 + M5 Studio 3.8

Studio 5.2

AlsoSAS 9?

EG 8.2

What’s New in SAS® Enterprise Guide 8.2

• Ability to connect directly to workspace servers

• New Git integration user interface

• Ability to access and run tasks from SAS Studio 5.2

• Ability to manage keyboard shortcuts

https://support.sas.com/software/products/enterprise-guide/faq/whatsnew.htm

Connect directly to workspace serversIf Viya, there are some things we need to do

• Add Your Certificates to the Windows CA Storehttps://go.documentation.sas.com/?activeCdc=pgmsascdc&cdcId=egcdc&cdcVersion=8.2&docsetId=secref&docsetTarget=n12036intelplatform00install.htm&locale=en

Cert must be added on all windoze servers that need to talk to CAS

New Git integration user interface

Same features as in SAS Studio 5.2 except support for:

• Stash

• Rebase

• Clone repos using SSH

Run tasks from SAS Studio 5.2

Manage Keyboard Shortcuts

What’s New in SAS® Studio 5.2

What’s New in SAS® Studio 5.2• Query tool and import tool

• Table viewer quick filter

• DATA step debugger

• Navigate file system and SAS Content

• Author and run SAS Viya jobs (think Stored Process)

• Dynamic and cascading prompts in CTM plus new tasks for Cloud Analytic Services, Machine Learning, and Time Series Modeling

• Background submit and scheduling

• Command line and keyboard shortcuts

• Pre and post custom code insertion

• Email code/log/results

• Git interface

Query Tool

• Select columns and Select all columns in a table

• Join (Inner, left, right, full), conditional (=, NOT =, <, >, <=, >=)

• Where (advanced expression and quick pick filter)

• Calculated columns

• Having and Group By

• FEDSQL generation option via Options > Preferences > Query > 'Generate FedSQL' checkbox

• Output options

Query Tool Join

Query Tool HAVING and GROUP BY

Query Tool Calculated Column/Expression Builder

Import Tool

• Import basic files using PROC import from the server file system (uploaded) or from local file system

• Simple options to configure resulting output data set

• Currently supports text based delimited files

• Excel, dBase, Stata, JMP, Paradox, SPSS are supported in Viya 3.5 release.

Import Tool

Table Viewer & Quick Filter

• Quick Filter for point and clicks interface to filter the table by the column data

• Show distinct rows (all columns or selected columns)

• Open in a query

• Increased maximum columns and rows per page to 1000

• Sort on more than one column

DATA Step Debugger

• Step through data step code

• Evaluate variables (shows value in pane to right)

• Watch on variable (breaks when value changes)

• Hard breakpoints

• Console output

DATA Step Debugger

File and Content Navigation

• Access files and folders on both the SAS Content server and your server file system from the Explorer section of the navigation pane.

• Administrators can control whether the server file system is displayed using configuration in SAS Environment Manager - sas.studiovdefinition -> showServerFiles.

Authoring and Running SAS Viya Jobs

• A Job is a way for a SAS programmer, with little or no web development experience, to create a browser-based interface for their code

• SAS code can be encapsulated in a job definition and its execution URL can be shared with others who can then run it in their web browser or in SAS Studio

• An HTML form or a task prompt can be associated with the job to provide a user interface which passes values into the code using global macro variables.

• When running a SAS job, SAS Studio uses the SAS Job Execution Web App.

Authoring a SAS Viya Job

Tasks and the Common Task Model

• Dynamic and cascading prompts in CTM

• New tasks for Cloud Analytic Services, Machine Learning, and Time Series Modeling

Background Submit

• Submit in the background static copy of code

• Represented in the submission status view

• Schedules an immediate job and runs it

• If long running, can disconnect and reconnect; will show up next login

• Does not interfere with interactively submitted code

Scheduling

• Schedule a static copy of code to run later or repeatedly based on a trigger

• Results and jobs are managed through a new Manage Jobs view (edit trigger, delete, unscheduled)

• Jobs can also be managed in Environment Manager

• Run now will run the job through the SAS Job execution app.

• Can create a job from an existing SAS program, then schedule later

Scheduling

Command Line

• Simple input to control the application via a command line

• Can chain commands together

Keyboard Management

• Manage and redefine predefined keyboard shortcut.

• List of shortcuts are extensive

• Add an alternate keyboard shortcut

• Manage keyboard shortcuts for either Microsoft Windows or Apple OS

• Export and import shortcut mappings

Insert Custom Code

• Allows for the user to define pre and post submission code to be run with each submission

• User written code is prepended or appended to the source for each type supported (program, task, query, import)

Email Code, Log, and Results

Git Integration

• Replaces Studio 3.8 feature set and adds more

• Provides ability to clone a repository or add existing ‘local’ repository (relative to SAS file system)

• Features include commit, stage, pull, push, fetch, branch, stash, history, reset, rebase, merge

Git Integration

Favorites and Tab Layout

Favorites

• Create and remove a favorite for any file type we support

• Favorites can be added from any other panel

• Provides a shortcut to the content for easy access

• Surfaced in the Explorer pane under the My Favorites folder

Tab Layout

• Preference setting to define how log, results, data and listings are arranged

• Preference setting to define which generated result is displayed

• Can override default setting and control within each view

New PreferencesStartup• Restore open folder state in explorer paneGeneral• Activate output tab, automatically open Last table, First table or none

• Program tab layout: default to vertical, horizontal split or standard layout• Show suggested commands on the command bar• Dark theme “Ignite” is now availableCode and Log• Show custom code in the SAS log• Tab display options for preview of code submission results

Results• Ability to turn on/off HTML outputImport• Tab display options for preview of code submission results

New PreferencesEditors• Individually control pairing brackets (Parentheses, Braces, Square brackets, Angle

brackets)• Show invisible characters• Change background color• Show line-length guide – show a guide line at a particular columnTables• Rows per page now allows up 1000 rows over previous 500

• Columns per page allows up 1000 columns over previous 300• Support for UPCASE variable name policyTasks• Tab display options for preview of code submission resultsQuery• Set the default columns to display on the Select tab (Source, Label, Aggregate, Format)

• Tab display options for preview of code submission results• Generate FedSQL instead of SQL

sas.com

Thank you!www.sas.com/fans

what’s new in - sas institute€¦ · •author and run sas viya jobs (think stored process) •...

Documents

sas viya 3.4 administration: configuration properties

navigating security information in sas viya 3.5 and sas 9

sas viya 3.3 administration: configuration propertiessas®...

come on, baby, light my sas® viya®: programming … ·...

proper planning prevents possible problems: sas® viya...

sas viya 3.4 administration: programming run-time servers

paper sas2260-2018 environment manager – a sas viya...

discovering sas viya: special collection

sas viya 3.3: overview

sas viya 3.5 administration: models

sas viya 3.5 administration: tuning

sas viya programming: getting started

date title s€¦ · 11 jan sas® viya and open source 12...

coding in sas® viya®...speed for base sas programs...

sas viya : a journey in statistics canada’s...

sas viya 3.5 administration: general servers and services

sas viya 3.4 for windows: deployment guide

multi-tenancy in sas® viya®: considerations and...

sas viya 3.4 administration: promotion (import and export)

data step in sas® viya™: essential new features · mwsug...