[PDF] [PDF] Chapter 2: Technology and Architecture

http://go documentation sas com/api/docsets/basewn/9 4/content/basewn pdf • Google is your Write to a SharePoint Document Library ➢ Read stream enables you to create text content rather than the usual SAS output PROC ODSTEXT 



Previous PDF Next PDF





[PDF] Efficient implementation and applications of PROC HTTP in analysis

User authentication is required to access files and data stored in SharePoint via SAS in the same way that it would be for accessing via the web However, rather  



[PDF] REST Just Got Easy with SAS® and PROC HTTP

6 avr 2020 · The HTTP procedure in SAS® has enabled developers to use REST APIs simply PROC HTTP has been given quite a few updates to make using this great 



[PDF] 2012 Reading Microsoft Sharepoint List Data Using SAS

22 oct 2012 · SAS Reading Sharepoint ▫ issue the HTTP request to the web service proc http in = request out = listout url = "&url" method = "get" ; run;



[PDF] Data Visualization from SAS® to Microsoft SharePoint - SAS Support

“Releasing the Power of SAS® into Microsoft SharePoint”, this paper expands on This example uses PROC SGPLOT to create a bar chart to show frequency by refer to this web page for more details: http://support sas com/kb/53/367 html



[PDF] Whats New in SAS 94

SAS Web Parts 6 1 for Microsoft SharePoint 80 A new logger enables logging of HTTP traffic through the SAS Logging Facility support for the use of array-structured data in function definition (via PROC FCMP)



[PDF] Chapter 2: Technology and Architecture

http://go documentation sas com/api/docsets/basewn/9 4/content/basewn pdf • Google is your Write to a SharePoint Document Library ➢ Read stream enables you to create text content rather than the usual SAS output PROC ODSTEXT 



[PDF] Whats New in SAS® 94 and SAS® Viya® 33 - My WordPress

12 fév 2018 · SAS Web Parts 6 1 for Microsoft SharePoint PROC HTTP adds a DEBUG statement, the TIMEOUT= procedure option, and response status 



[PDF] SAS 94ステートメント:リファレンス第4版

FILENAME ステートメント、WebDAV アクセス方式を使用して、SharePoint 態になると、HADOOP、HTTP、SOAP の各プロシジャもロックダウン状態に 後続の DATA ステップおよび PROC ステップには、オブザベーションを含まな



[PDF] Installation Instructions and System Administrators Guide for

Visit the new Web page http://www sas com/newversion for information about what is APPLETLOC, run PROC OPTIONS or view the SAS configuration file F a WebDav-compliant server, such as Intraspect or Microsoft SharePoint Portal  

[PDF] sas proc https

[PDF] sas proc json write values

[PDF] sas proc sql create table as select

[PDF] sas proc sql create table join

[PDF] sas proc sql create table like

[PDF] sas proc sql create table replace

[PDF] sas proc sql create table syntax

[PDF] sas proc sql format

[PDF] sas proc sql; create table as select example

[PDF] sas retain array

[PDF] sas sum(of array name * )

[PDF] sascrunch arrays

[PDF] sassen cities in a world economy pdf

[PDF] sassen the global city new york london tokyo

[PDF] sat interventions

Copyright © SAS Institute Inc. All rights reserved.

BASE SAS 9.4 and Enterprise Guide 7.15

What a difference a version makes!

Copyright © SAS Institute Inc. All rights reserved. 2

SAS 9.4 & SAS EG New Features

2 ‡Highlight ͞some" of the new features in the platform ‡Show you how/where to find out more on these features

‡There are a LOT of new features

‡ Not all features will be covered or explained in detail

‡SAS 9.4

‡SAS EG

‡SAS Add-in for Microsoft Office

Copyright © SAS Institute Inc. All rights reserved. 3

Handy Links

‡SAS 9.4 New Features Guide

‡Main Enterprise Guide documentation page

‡Download SAS formats & catalog task (for versions before EG 7.15)

‡Creating accessible results

‡Open programs in text editor

‡What's new in SAS Enterprise Guide

‡Configure SAS Enterprise Guide for grid computing ‡Parallel execution of branches in SAS Enterprise Guide ‡Increase your productivity with new features of SAS Enterprise Guide

‡SAS Add-In 7.15 for Microsoft Office

Copyright © SAS Institute Inc. All rights reserved. 4

Handy Links: Forums, Blogs etc

‡Blogs : http://blogs.sas.com

‡SAS Forums: https://communities.sas.com/

‡Support Home Page: https://support.sas.com/en/support-home.html ‡SAS Documentation: http://support.sas.com/documentation/

‡SAS 9.4 New Features Guide:

‡Google is your friend: https://www.google.ca/

Copyright © SAS Institute Inc. All rights reserved. 5

SAS Enterprise Guide New Features Help

In EG, go to:

Help > SAS Enterprise Guide Help

Example:

Copyright © SAS Institute Inc. All rights reserved.

BASE SAS 9.4

Data Access and Environment

Output Delivery System

SAS/GRAPH and SAS/STAT

Language Elements and Procedures

Copyright © SAS Institute Inc. All rights reserved. 7

DATA Access

¾Improved Performance

¾Increased Security

¾Process time and datetime values by using time zones

¾Manage locale information in a data set

Copyright © SAS Institute Inc. All rights reserved. 8

DATA Access

¾SAS data sets can be written to an external file in

JSON representation (JavaScript Object Notation)

¾Write to a SharePoint Document Library

¾Read stream data and user text

Copyright © SAS Institute Inc. All rights reserved. 9

DATA Access

¾Extended Attributes

¾Zip File access method

¾New Access Methods

Copyright © SAS Institute Inc. All rights reserved. 10

DATA Access: SAS/ACCESS To PC Files

¾new SAS LIBNAME engine called XLSX. It enables you to directly read and write data between Microsoft Excel XLSX files and SAS on Linux, UNIX, and Microsoft Windows operating environments. ¾SAS/ACCESS 9.4 Interface to PC Files has a number of enhancements to support Microsoft Excel XLSX files. For example, you can add a new Microsoft Excel XLSX worksheet to an existing workbook, and you can replace an existing worksheet in a workbook. ¾SAS/ACCESS 9.4 imports data from JMP files saved in JMP 7 or later formats, and it exports data to files in JMP 7 or later formats. Copyright © SAS Institute Inc. All rights reserved.

BASE SAS 9.4

Data Access and Environment

Output Delivery System

SAS/GRAPH and SAS/STAT

Language Elements and Procedures

Copyright © SAS Institute Inc. All rights reserved. 12

New ODS destinations

¾EPUB, HTML5, Layout, Microsoft PowerPoint and Excel.

Note: Create Two Content on same slide

Copyright © SAS Institute Inc. All rights reserved. 13

New ODS Procedures

ODSLIST Procedure

enables you to create text content rather than tables. PROC ODSLIST creates lists that can be customized

ODSTABLE Procedure

enables you to create table templates and bind them with the input data set in one statement. You can also name your templates and store them in a template store

ODSTEXT Procedure

enables you to create text content rather than the usual SAS output. PROC ODSTEXT creates lists and paragraphs for your output.

Note: Create TwoContent on same slide

Copyright © SAS Institute Inc. All rights reserved. 14

Enhancing Output

¾Use the ODS Report Writing Interface (RWI) to create and manipulate predefined ODS objects in a DATA step to create highly customized output. http://support.sas.com/rnd/base/ods/Tipsheet_RWI.pdf ¾Arrange ODS output objects exactly where you want them on a page ¾Dynamic placement of objects by using a grid structure (ODS Layout) ¾Animate multi-page GIF images and SVG files by setting system options. ¾A new procedure, MSCHART, creates (native Excel Graphs) charts that can be opened and manipulated in Microsoft Excel (preproduction). ¾Universal printing: TIFF images, EMFPlus, EMFDual metafile formats. Plus new fonts available. Copyright © SAS Institute Inc. All rights reserved. 15

Reports and ODS

¾ODS Statistical Graphics

The ODS Graphics products

provide several new plot types and capabilities, including axis tables that create an axis-aligned row or column of textual data. Copyright © SAS Institute Inc. All rights reserved.

BASE SAS 9.4

Data Access and Environment

Output Delivery System

SAS/GRAPH and SAS/STAT

Language Elements and Procedures

Copyright © SAS Institute Inc. All rights reserved. 17

SAS/STAT

¾GEE (preproduction)

‡The GEE procedure implements the generalized estimating equations (GEE) approach (Liang and Zeger 1986), which extends the generalized linear model to handle longitudinal data

¾ICPHREG

‡The ICPHREG procedure is designed to fit proportional hazards regression models to interval-censored

data. It can also fit proportional hazards regression models to failure time data that are uncensored, right

censored, or left censored.

¾SPP

‡The SPP procedure performs analysis for spatial point patterns in two dimensions. Copyright © SAS Institute Inc. All rights reserved. 18

SAS/GRAPH

¾There are three new Universal Printer shortcut devices: EMFDUAL, TIFF, and TIFFK. ¾The SVG and GIF devices now support animation. ¾The Annotate Facility has several enhancements. ¾The GEOCODE procedure now supports Canadian street geocoding. ¾%GEOBASE2GEOCODE macro program for importing Canadian roadway

¾Ability to produce Google-like maps

¾The map data sets in the MAPSGFK library have been updated. Copyright © SAS Institute Inc. All rights reserved. 19

SAS/GRAPH Examples

19

Canadian Street level Geocoding.

Street lookup data downloaded from SAS MapsOnline

Copyright © SAS Institute Inc. All rights reserved.

BASE SAS 9.4

Data Access and Environment

Output Delivery System

SAS/GRAPH and SAS/STAT

Language Elements and Procedures

Copyright © SAS Institute Inc. All rights reserved. 21

New Interface: SAS Studio

Copyright © SAS Institute Inc. All rights reserved. 22

Data Step Language Elements

¾Dataset Options

9The new ENCRYPTKEY= data set option specifies a key value. This enables you to use AES

(Advanced Encryption Standard) encryption.

9The enhanced ENCRYPT= data set option now supports AES encryption. This enables you

to use the AES algorithm for stronger encryption.

¾Formats & Informats

9New ISO 8601 formats: e.g. Adjusts a Coordinated Universal Time (UTC) value to the user

local date and time (e.g.: B8601Dx.)

¾Functions

9COT (cotangent), CSC (cosecant), SEC (secant)

Copyright © SAS Institute Inc. All rights reserved. 23

Language Elements

¾Statements

9ODS (EPUB, HTML5, etc.)

9Filename for ZIP and DATAURL

¾System Options

9VARINITCHK

9DATAPAGESIZE, ALIGNSASIOFILES, STRIPESIZE, etc.

9Support for animated GIF

9Support for UTC

9DSACCEL

¾New automatic macro variables

9SYSDATASTEPPHASE , SYSHOSTINFOLONG, SYSPROCESSMODE

9SYSTIMEZONE, SYSTIMEZONEIDENT, SYSTIMEZONEOFFSET

Copyright © SAS Institute Inc. All rights reserved. 24

Procedures

24

¾PROC DELETE

¾PROC PRESENV

¾PROC STREAM

¾PROC JSON

Copyright © SAS Institute Inc. All rights reserved. 25

Base SAS

Programming Languages

Two new programming languages:

DS2

FedSQL

Copyright © SAS Institute Inc. All rights reserved. 26

New Programming Languages

DS2 Language

¾new SAS proprietary programming

language

¾appropriate for advanced data

manipulation and applications

¾includes additional data types, ANSI

SQL types, programming structure

elements, user-defined methods, and user-defined packages

¾several DS2 language elements accept

embedded FedSQL syntax

Example:

Copyright © SAS Institute Inc. All rights reserved. 27

PROC DS2

Why should I use it?

¾Additional precision gained from using new data types ¾Threaded processing for computationally intensive processing ¾Methods and packages for easy deployment of reusable code modules ¾Embedded PROC FedSQL - DATA step power and SQL simplicity all in the same program ¾Code can be run inside massively parallel databases like Teradata, Hadoop and

Greenplum

Blog: Reasons to love PROC DS2

Similarities between DS2 and the DATA Step

Differences between PROC DS2 and the DATA Step

quotesdbs_dbs17.pdfusesText_23