SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Leonid BatkhanMarch 4, 2016 16

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

Data Management | Programming Tips

Mary Kathryn QueenFebruary 17, 2016 2

DataFlux Data Management Server 2.7: REST APIs

REpresentational State Transfer (REST) is an architectural style for designing web services that access a system's resources using HTTP methods. With the release of DataFlux Data Management 2.7 earlier this year, three new REST Application Programming Interfaces (APIs) are now available: Data Management Server Batch Jobs Data Management Server Real-time

English

Data Management | Programming Tips

Nicolas RobertFebruary 11, 2016 2

Data Governance Series: Share DataFlux Data Quality profiling metrics in SAS Visual Analytics

This is my first blog post, and the first of a long series around Data Governance. The first thing I want to discuss is the ability to Share DataFlux Data Quality profiling metrics in SAS Visual Analytics. This post will illustrate how to extract profiling data from the DataFlux repository

English

Programming Tips | SAS Administrators

Edoardo RivaFebruary 9, 2016 1

New year resolution: Don't let old stuff slow down your SAS Grid

As another year goes by, many people think about new year’s resolutions. It’s probably the third year in row that I’ve promised myself I’d start exercising in the fabulous SAS gym. Of course, I blame the recently concluded holiday season. With all the food-focused events, I couldn’t resist, ate way

English

Programming Tips | SAS Administrators

Bobbie WagonerFebruary 8, 2016 1

Accessing the provided Relationship Report in SAS Visual Analytics 7.3

In SAS Visual Analytics 7.3, the usage reports accessed from the administrator includes a relationship report. This report provides very basic lineage and dependency information for selected object types. The data to populate this report comes from the middle-tier relationship service. Once you enable the collection and extraction of this

English

Learn SAS | Programming Tips

Leonid BatkhanFebruary 4, 2016 14

Introducing data-driven loops

Programming loops are a staple of any computer programming language. In essence, loops are what make programming languages so powerful. In all programming loops, a group of statements is executed repeatedly based on the value of an index variable that changes from one iteration to another. The iterations are continued

English

Programming Tips | SAS Administrators

Gerry NelsonJanuary 26, 2016 1

What is going on with my Visual Analytics audit data archiving?

In my last blog (What is going on with my Visual Analytics audit data collection) I reviewed how middle-tier auditing works and where to look for logs to debug issues. In this follow up blog I will do the same for the Visual Analytics audit data archiving process. The archive process is

English

Blogs

Blogs

Programming Tips