The SAS Dummy

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Chris HemedingerJune 28, 2013 2

Building an SQL subquery in SAS Enterprise Guide

Many SAS Enterprise Guide users practically live in the Query Builder. For those who understand their data tables, the Query Builder provides a tremendous amount of flexibility to pull and manipulate data. The Query Builder produces SQL programs behind the scenes, which translates well for database-centric work. Sometimes a complex

English

Programming Tips

Chris HemedingerJune 12, 2013 35

How to build a correlations matrix heat map with SAS

If you've watched any of the demos for SAS Visual Analytics (or even tried it yourself!), you have probably seen this nifty exploration of multiple measures. It's a way to look at how multiple measures are correlated with one another, using a diagonal heat map chart. The "stronger" the color

English

Programming Tips | SAS Events

Chris HemedingerJune 9, 2013 80

Build your own SAS client app with Microsoft .NET

As part of my follow-up to SAS Global Forum 2013, I've posted a few articles about how to create your own client apps with SAS Integration Technologies. This article shows how to use Microsoft .NET -- the same approach used for SAS Enterprise Guide and SAS Add-In for Microsoft Office

English

Programming Tips

Chris HemedingerJune 4, 2013 11

How to find the ENGINE name for a SAS library

One of the great things about SAS libraries is that you can write your programs to read and write data without having to worry about where the data lives. SAS data set on a file system? Oracle table in a database server? Hadoop data in Hive? For many SAS applications,

English

Learn SAS | Programming Tips

Chris HemedingerMay 20, 2013 63

Export and download any file from SAS Enterprise Guide

Last week I alluded to some very useful applications of the Copy Files task. This is one of them. If you have SAS Enterprise Guide 7.13 or later, the Copy Files task is in the Tasks->Data menu. In earlier versions, you'll have to download/install the task as a custom task.

English

Programming Tips

Chris HemedingerMay 19, 2013 15

Special steps for installing the custom tasks that you download

Recent versions of SAS Enterprise Guide (version 5.1 and later) use Microsoft .NET 4.0, which enforces additional security requirements before running custom task DLLs that you download from the Web, including those that you download from support.sas.com. Because these task DLLs are downloaded from the (big and scary) Internet, the

English

Programming Tips

Chris HemedingerMay 16, 2013 12

An FTP-style task in SAS Enterprise Guide: user-driven fixes

A few months ago I released the Copy Files task for use with SAS Enterprise Guide. The task allows you to transfer any files between your PC and a SAS Workspace session, much like an FTP process. It doesn't rely on FTP though; it uses a combination of SAS code,

English

Programming Tips | SAS Events

Chris HemedingerMay 7, 2013 2

SAS Enterprise Guide: for all of the hats that you wear, you're covered

Even though it's been around for well over a decade, SAS Enterprise Guide was still a hot topic among attendees at SAS Global Forum this year. In the Technology Connection -- the big session on Monday morning -- SAS R&D staff used the conference agenda content to demonstrate the power

English

Learn SAS | Programming Tips

Chris HemedingerMarch 25, 2013 3

Upcoming SAS Talks: Getting started with SAS

Are you a new SAS user who isn't sure where to begin? Have no fear, because you're not alone. Here at SAS, we often receive questions from people who need help getting started with the software. Getting Started with SAS is the topic of a SAS Talks session that I

English

Programming Tips

Chris HemedingerMarch 6, 2013 12

Using SAS to count the number of LinkedIn "shares" for your article

Last year I shared this popular tip for counting how many times a web link has been shared on Twitter or Facebook. I use this technique daily to report on the social media "popularity" of our blog articles at SAS. I wanted to add LinkedIn into the mix. Like Twitter

English

Blogs

Blogs

Programming Tips