SAS Users

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

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

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

Blogs

Blogs

Programming Tips