Tips and tricks and the latest SAS news

 ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ ‌ 
View as a web page
 
SAS The Power to Know logo
 
SAS Tech Report

SAS® Tech Report
December 2016
sas.com | email the editor

Dear Reader,

I can’t believe the calendar on my wall says December. I don’t know about you, but I’m just now getting used to writing “2016” on checks and other documents. And now the year is coming to an end? Guess in a couple of weeks I'll start misdating my checks all over again.

The new year brings good news too. SAS® Global Forum 2017 is right around the corner. This year the event takes place in Orlando, FL, on April 2-5. Registration is now open, and hundreds of SAS users from all over the world have already registered. If you’re considering going, you can find an agenda of events and an early preview of the sessions on the conference website. If you’re a SAS user, there just isn’t a better conference to learn about new SAS technology, acquire new SAS skills and network with your peers.

To get you excited about SAS Global Forum, and to give you an idea of some of the outstanding presentations you’ll enjoy, I thought I would share with you the top 10 most popular video presentations from SAS Global Forum 2016, ranked by views from the SAS Global Forum 2016 video portal. (You can view all presentations from last year, hundreds of them, at the SAS Global Forum 2016 conference proceedings page.)

1. A Macro That Can Fix Data Length Inconsistency and Detect Data Type Inconsistency
2. Is It Time for a PhD in Data Science?
3. Be More Productive! Tips and Tricks to Improve your SAS Programming Environment
4. Becoming a Unicorn, a Leprechaun or a Good Marketing Analyst: Fairy Tales Can Come True
5. Integrated Marketing With SAS in the Age of Real Time
6. What's the Difference?
7. Change Management: The Secret to a Successful SAS Implementation
8. A Survey of Some Useful SAS Functions
9. The Combination of SAS and VBA Makes Life Easier
10. Nine Frequently Asked Questions About Getting Started With SAS Visual Analytics

I hope you enjoy listening to these talks and perusing the full proceedings from 2016. I look forward to seeing you in Orlando next April.

And since I won’t talk with you again until the next issue in January 2016 (...I mean January 2017!) – happy holidays and best wishes for the new year!

Larry LaRusso
Editor, SAS Tech Report
Follow me: @lalaru102
 

SAS Tips and Tricks

 
Compute a moving average in SAS®

Compute a moving average in SAS®

This article from SAS’ Rick Wicklin shows you how to use PROC EXPAND and contains links to articles that use the DATA step or macros to answer a common user question: How do I compute a moving average in SAS?

 

Get started with SAS® Visual Statistics

Get started with SAS® Visual Statistics

SAS Visual Statistics is a web-based solution that offers an interactive, drag-and-drop interface to rapidly build and modify predictive models. In this video tutorial, you’ll get an introduction to SAS Visual Statistics, the interface and main features, and learn how to get started.

 

What does it mean to administer SAS® Visual Analytics?

What it means to administer SAS® Visual Analytics

This Ask the Expert on-demand webinar helps you understand and perform administrative tasks that are specific to SAS Visual Analytics. To get the most out of the session, it would be helpful to have a familiarity with the SAS Business Intelligence platform.

 

Ron Cody’s Tips on Using SAS® University Edition

Ron Cody’s Tips on Using SAS® University Edition

SAS author Ron Cody wants to make sure you’re not confused by the word "university" in SAS University Edition. You don’t have to be a university student; anyone can download the free software (as long as they’re using it for learning purposes). Check out Ron’s top tips for using the software.

 

Send your SAS® graphs to Excel, directly to Excel ...

Send your SAS® graphs to Excel, directly to Excel ...

If you’re the lone SAS programmer in your organization, chances are you’re getting data from others as an Excel spreadsheet. Luckily in SAS 9.4 (TS1M3), there's an easy new way to send your output (including SAS graphs) to Excel. Directly to Excel! (Do not pass go, do not collect $200!)

 

How to reorder the variables in a SAS® data set

How to reorder the variables in a SAS® data set

Several statements can be used to change the order of the variables in a SAS data set. However, in order for any of these statements to have the desired effect, they must be placed before a SET, MERGE or UPDATE statement in the DATA step. This sample shows you specifically how to use the RETAIN statement to reorder your variables.

Reading data with the SAS® JSON libname engine

Reading data with the SAS® JSON libname engine

With the proliferation of REST-based APIs and web services, SAS users needing to access JSON data has skyrocketed. For those users, SAS’ Chris Hemedinger has good news: SAS 9.4 M4 now has a built-in LIBNAME engine for JSON.

 

Modifying variable attributes in all data sets of a SAS® library

Modifying variable attributes in all data sets of a SAS® library

Modifying SAS variable attributes such as name, format and label is easy using the DATASETS procedure. But what if we need to change variable attributes in all tables of a data library where that variable is present? Here are programming techniques to solve the problem of modifying variable attributes across all data sets of a data library.

 

 

From SAS Communities

 
Executing SAS® Viya™ code in SAS® Enterprise Miner™

Executing SAS® Viya™ code in SAS® Enterprise Miner

This article shows SAS Enterprise Miner users (whose organizations are evolving their analytics environments with SAS Viya) how to take advantage of what SAS Viya has to offer without losing their investments in SAS Enterprise Miner projects.

 

How to insert a new column into a data set using PROC SQL

How to insert a new column into a data set using PROC SQL

SAS Communities contributor Mike Davis asks: “How do you insert/update a new column into a data set using PROC SQL?” The SAS community responds with multiple solutions and code to answer this question.

 

SAS launches new SAS® Global Forum community

SAS launches new SAS® Global Forum community

Interested in attending SAS Global Forum 2017? Check out the new SAS Global Forum community. It’s the place to go to learn more about what’s going on at the event and to connect with other attendees before heading off to Orlando.

 

SAS News

 
SAS® 9.4 M4 and SAS® Analytics 14.2 releases are now available

SAS® 9.4 M4 and SAS® Analytics 14.2 releases are now available

With SAS 9.4 TS1M4, SAS Analytics 14.2, and new releases of key SAS Data Management and SAS Decision Management products, SAS continues to deliver innovative solutions to meet your current and future needs. And you can integrate your SAS 9.4 and SAS Viya environments with bridges to take advantage of both worlds. Learn more.

 

SAS® Global Forum 2017 Users Program registration now open

SAS® Global Forum 2017 Users Program registration now open

Register today to join over 5,000 SAS users and experts in Orlando, FL, April 2-5. Save now with the early-bird discount.

 

 

SAS® Tech Report

About this email:
Don't miss important updates from SAS! Please add sas.com as a domain in your safe sender list. Want to get more out of your relationship with SAS? Create a SAS profile.

SAS places great value in fair information practices and in connection with the management of our contact database, we would like to remind you that SAS Institute Inc. may use your personal contact details for marketing purposes, as stated in the SAS Privacy Statement. If you do not want SAS Institute Inc. to contact you by email for marketing purposes, please opt out here. To contact SAS via postal mail: SAS, SAS Campus Drive, Cary NC 27513 USA. ATTN: Legal Division/Privacy Manager.

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 and product names are trademarks of their respective companies.

Copyright © SAS Institute Inc. All rights reserved.