The SAS Dummy

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Chris HemedingerJuly 3, 2017 28

Ten SAS Enterprise Guide program editor tricks

If you spend a lot of time in SAS Enterprise Guide (as I do), you probably get to know its features pretty well. But we don't always take the time to explore as we should, so there might be a few golden nuggets of editor knowledge that have escaped you

English

Machine Learning | Programming Tips

Chris HemedingerJune 28, 2017 9

Using Python to work with SAS Viya and CAS

One of the big benefits of SAS Viya is how approachable it is for programmers of other languages. You don't have to learn SAS in order to become productive quickly. We've seen a lot of interest from people who code in Python, maybe because that language has become known for

English

Programming Tips | SAS Administrators

Chris HemedingerMay 30, 2017 11

Create and run SAS code in SAS Add-In for Microsoft Office

When SAS Add-In for Microsoft Office was first created over a decade ago, SAS programmers were told to check their skills at the door. This new product was for non-programmers only. SAS programmers were invited to contribute to the experience by packaging their code in SAS stored processes, which end

English

Programming Tips

Chris HemedingerMay 7, 2017 5

How to download and convert CSV files for use in SAS

In his recent article Perceptions of probability, Rick Wicklin explores how vague statements about "likeliness" translate into probabilities that we can express numerically. It's a fun, informative post -- I recommend it! You'll "Almost Certainly" enjoy it. To prepare the article, Rick first had to download the source data from

English

Programming Tips

Chris HemedingerApril 14, 2017 55

Using SAS to access Google Analytics APIs

Every day before I even wake up, I have little "SAS robots" that do work for me. These are SAS batch jobs that gather data from external services and build data marts, generate reports, and send e-mail. One of those SAS jobs gathers Google Analytics data about our SAS blogs

English

Advanced Analytics | Learn SAS | Machine Learning | Programming Tips

Chris HemedingerApril 8, 2017 29

Introducing SASPy: Use Python code to access SAS

Thanks to a new open source project from SAS, Python coders can now bring the power of SAS into their Python scripts. The project is SASPy, and it's available on the SAS Software GitHub. It works with SAS 9.4 and higher, and requires Python 3.x. I spoke with Jared Dean

English

Programming Tips

Chris HemedingerMarch 27, 2017 8

How many records are in that PROC SQL result?

Did you know that PROC SQL captures the record count for a result set in a special automatic macro variable? When you create a subset of data to include in a report, it's a nice touch to add a record count and other summaries as an eye-catcher to the report

English

Programming Tips

Chris HemedingerFebruary 7, 2017 1

Tip for coding your color values in SAS Enterprise Guide

Colors are the subject of many romantic poems and songs, but there isn't much romance to be found in their hexadecimal values. With apologies to Van Morrison: ...Skipping and a jumping In the misty morning fog with Our hearts a thumpin' and you My cx662F14 eyed girl When it comes

English

Programming Tips

Chris HemedingerJanuary 5, 2017 6

Reporting on GitHub accounts with SAS

At SAS, we've published more repositories on GitHub as a way to share our open source projects and examples. These "repos" (that's Git lingo) are created and maintained by experts in R&D, professional services (consulting), and SAS training. Some recent examples include: sas_kernel, which provides Jupyter notebook support for SAS.

English

Data Management | Programming Tips

Chris HemedingerDecember 2, 2016 58

Reading data with the SAS JSON libname engine

JSON is the new XML. The number of SAS users who need to access JSON data has skyrocketed, thanks mainly to the proliferation of REST-based APIs and web services. Because JSON is structured data in text format, we've been able to offer simple parsing techniques that use DATA step and

English

Blogs

Blogs

Programming Tips