SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Edoardo RivaApril 6, 2016 7

One of the hidden gems of SAS Studio is the ability to run process flows in parallel. This feature really shines when used in a grid environment. Let’s discuss this one step at a time. First, what is a process flow? When working in the Visual Programmer perspective, you have

English

Programming Tips | SAS Administrators

Scott McCauleyApril 4, 2016 23

SAS Visual Analytics autoload configuration made easy

In the past, configuring a new autoload library for SAS Visual Analytics was a manual process involving steps to create very specific folder structures and to copy and edit scripts and SAS programs. No more! Updates to the SAS Deployment Manager have added a new task that creates and configures new autoload libraries

English

Programming Tips | SAS Administrators

Dave NadenMarch 30, 2016 0

Opening Up the SAS Environment Manager Report Center

The SAS Environment Manager Report Center is a set of SAS stored processes and SAS macros which leverage the SAS Data Mart for the purpose of monitoring and auditing a SAS installation. Full documentation on the structure and functioning of the Data Mart can be found in the SAS Environment Manager

English

Programming Tips

Bobbie WagonerMarch 22, 2016 16

Making Best Use of Date Formats in Visual Analytics Designer

You may have noticed that when using date information in SAS Visual Analytics, that the date data values can be displayed in a variety of ways. You may see your dates displayed like Jan1916, 03Jun1915, or 03/12/16, for example. In this blog I’ll help you understand SAS date and time

English

Programming Tips

Kevin RussellMarch 11, 2016 7

Using a pipe to return the output of an operating system command to SAS® software

Being able to access information about your operating system from within SAS can be incredibly useful. For example, if you have a directory that contains an unknown number of CSV files that you would like to read into SAS, you certainly would not want to have to write an IMPORT

English

Data Management | Programming Tips

Nicolas RobertMarch 7, 2016 2

Data Governance Series: Share DataFlux Data Quality profiling metrics in SAS Visual Analytics (Part 2)

In this post, I continue the journey of getting data profiling results into SAS Visual Analytics. In my first blog I described the process of collecting DataFlux Data Quality profiling metrics to load a datamart. Now we load this datamart into memory (LASR) and then plug a VA report on

English

Learn SAS | Programming Tips

Leonid BatkhanMarch 4, 2016 16

Data-driven SAS macro loops

In my previous post, Introducing data-driven loops, I suggested a way of implementing programming loops with a list of index variables pulled from an external data table. These ordinary programming loops iterate during code execution while processing some data elements of an input data table. SAS macro loops, on the

English

Programming Tips

Edoardo RivaMarch 1, 2016 4

Avoid the pitfalls of parallel jobs

I recently received a call from a colleague that is using parallel processing in a grid environment; he lamented that SAS Enterprise Guide did not show in the work library any of the tables that were successfully created in his project. The issue was very clear in my mind, but

English

Programming Tips | SAS Administrators

Uttam KumarFebruary 22, 2016 0

Copy data to Hadoop using SAS Data Loader

The SAS Data Loader directive ‘Copy Data to Hadoop’ enables you to copy data from DBMS to Hadoop Hive tables. The SAS Data Loader for Hadoop can be configured to copy data from any external database which offers JDBC database connectivity. SAS Data Loader uses the Apache Sqoop™ and Oozie

English

Programming Tips

Kim WilsonFebruary 19, 2016 9

Reasons to love PROC DS2

PROC DS2 (DS2) is a new SAS programming language that extends the power of the traditional DATA step. Some customers have wondered if this new functionality is simply the “DATA step on steroids,” meaning that we simply added more robust functionality so that it’s a replacement for the DATA step.

English

Blogs

Blogs

Programming Tips