Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips | SAS Administrators

Rob CollumMay 29, 2015 0

How SAS gets to data in Hadoop

SAS offers a rich collection of features for working with Hadoop quickly and efficiently. This post will provide a brief run-through of the various technologies used by SAS to get to data in Hadoop and what’s needed to get the job done. Working with text files Base SAS software has the

Read More

Learn SAS | Programming Tips

Charu ShankarMay 27, 2015 0

Life saver tip for comparing PROC SQL join with SAS data step merge

“Phew! That tip alone was a life saver,” said a student in one of my SAS SQL classes. “Before, I would have to read about ten Google search results before I could find that content of the sort you shared in class.” That student was referring to the tip I

Read More

Programming Tips

Bari LawhornMay 20, 2015 0

ODS PDF destination in SAS 9.4: Come take a look under the hood!

If you have programmed with SAS in the last 15 years, you have probably had a reason to share your SAS results in PDF format. The ODS PDF destination, much like a well-designed car, has evolved over the years, offering progressively nicer features like security, enhanced image formatting and embedded

Read More

Learn SAS | Programming Tips

Chris Hemedinger

Chris HemedingerMay 20, 2015 0

Using LIBNAME XLSX to read and write Excel files

The XLSX libname engine in SAS allows you to read and write Microsoft Excel files in the same way that you can work with other data sets and databases. This article describes the basic (and some limitations) of the XLSX engine.

Read More

Programming Tips

Visual Analytics localize report

Teri PatsilarasMay 15, 2015 0

SAS Visual Analytics: Localize your reports to support multiple languages!

Do you support a multilingual reporting audience? This is a fast-growing requirement for many of you, and now your SAS Visual Analytics reports can be easily configured to support any number of languages. From SAS Visual Analytics Designer, there is an option under the File menu called Localize Report. This

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMay 14, 2015 0

Filter your SAS Enterprise Guide data with a WHERE clause

Are you a VIEWTABLE fan from the SAS Windowing Environment (a.k.a. Display Manager, DMS, PC SAS)? If so, the latest version of SAS Enterprise Guide has a new feature that you'll love. With the latest update to SAS Enterprise Guide 7.1 (7.11), you can now subset your data in the

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonMay 12, 2015 0

Creating your own customized graphs for SAS analytic procedures

In recent releases of SAS, you can use Output Delivery System graphics or 'ODS graphics on' to produce nice graphical output for most of the analytic procedures. These default graphs are nice, but when you want your graphs to look "a certain way" SAS also lets you create your own custom graphs!

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMay 11, 2015 0

Using FILENAME ZIP to unzip and read data files in SAS

I've written about how to use the FILENAME ZIP method to read and update ZIP files in your SAS programs. The ZIP method was added in SAS 9.4, and its advantage is that you can accomplish more in SAS without having to launch external utilities such as WinZip, gunzip, or

Read More

Learn SAS | Programming Tips

Michael A. RaithelMay 8, 2015 0

Doctor, I have this friend who has a pain right about here

We have all heard the old joke about the person who sidles up to a doctor at a party and describes in great detail a medical problem a "friend" is having in order to get free medical advice. It could just as easily be a person buttonholing an accountant for

Read More

Learn SAS | Programming Tips

Charu ShankarMay 6, 2015 0

10 reasons to learn SAS code even when you have Enterprise Guide

New York City Mayor, Michael Bloomberg made a new-year's resolution to learn code. Apple’s Steve Jobs said, “I think everybody in this country should learn how to program a computer because it teaches you how to think.” President Barrack Obama said, "Don't just buy a new video game, make one.

Read More

Programming Tips | SAS Administrators | SAS Events

Rob CollumMay 6, 2015 0

SAS administration and architecture—highlights from SAS Global Forum 2015

I was privileged with the opportunity to present a couple of papers at SAS Global Forum 2015 in Dallas, Texas this year. While there, I was also excited to attend presentations with new and inventive approaches for working with the administration and architecture of SAS solutions. This is a collection

Read More

Data Visualization | Programming Tips

Robert AllisonMay 5, 2015 0

SAS/GRAPH: Intermediate Tricks (a Handbook for the Wizard’s Apprentice)

Did you ever wish you could master SAS/GRAPH, and create graphs and maps that were customized exactly like you wanted them? Then this free eBook is for you! Probably the most memorable book for me was the Necronomicon in the Army of Darkness movie. How many of you liked that

Read More

Programming Tips

Sunil GuptaMay 1, 2015 0

Converting variable types—use PUT() or INPUT()?

How many times have you had a need to convert between variable types such as converting character to numeric or numeric to character? For example, what if you have a character variable with numeric values but you need to perform some calculations? Or, if you have a numeric variable but

Read More

Programming Tips

Stephen FoersterApril 30, 2015 0

You react so quickly! Do you have ESP?

SAS Event Stream Processing that is! The latest release of SAS Event Stream Processing will launch May 12, and numerous customers around the globe are already using it. So what’s the big deal? Why event streams are important to business SAS Event Stream Processing allows organizations to react to events

Read More

Programming Tips

SAS JediApril 25, 2015 0

Jedi SAS Tricks: Warp Speed DATA Steps with DS2

I remember the first time I was faced with the challenge of parallelizing a DATA step process. It was 2001 and SAS V8.1 was shiny and new. We were processing very large data sets, and the computations performed on each record were quite complex. The processing was crawling along on

Read More

Programming Tips | SAS Administrators

Diagram showing SAS deployment defined as compute tier, metadata tier and middle tier.

Rob CollumApril 22, 2015 0

Deploying SAS software--save time and effort with shared configuration

SAS System software supports a wide variety architecture and deployment possibilities. It’s wild when you think about it because you can scale the analytic power of SAS from the humblest single CPU laptop machine all the way up to hundreds-of-machines clusters. When SAS deployments involve many machines, it’s natural to

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerApril 16, 2015 0

How to convert a Unix datetime to a SAS datetime

I watched with wonder as each of my daughters learned how to "tell time." Early in their primary school careers, they brought home worksheets that featured clock faces with big-hand/little-hand configurations that they had to decipher, and exercises that asked them to draw the hands as they should appear given

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonApril 13, 2015 0

Applying the KISS principle to maps: An analysis of breastfeeding prevalence

How simple is too simple, when it comes to analyzing data on a map? The KISS principle can be applied to many things, including graphs and maps. What is the KISS principle, you might ask? Well, it's not the rock band that my friend Patricia (pictured below) has been known

Read More

Programming Tips

Teri PatsilarasApril 10, 2015 0

Include Info Windows in your SAS Visual Analytics reports

An Info Window is a SAS Visual Analytics pop-up window that provides additional information when a user selects a report object. When designing your report, you can think of an Info Window as simply an additional report section that is defined as hidden. Now that you know what an Info

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonApril 7, 2015 0

Variations on a stickman graph: Analyzing the Twitter minions

One of our customers asked if I could show him how to reproduce a stickman graph that David McCandless (ala, Information is Beautiful) had created - see screen capture below. I'm not sure that it's the best kind of graph for the occasion, but of course SAS can be used

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerApril 3, 2015 0

How to compare SAS programs in SAS Enterprise Guide

Copy/paste is my favorite method for creating new SAS programs. In my work projects, I maintain a sort of genealogy of SAS programs, because the DNA of one program can be used to spawn many other SAS programs as its progeny. When things (inevitably) aren't working as I intend in

Read More

Programming Tips | SAS Events

Christina HarveyApril 2, 2015 0

SAS Global Forum 2015: writing SAS code for a production environment

Last week, Sara Jones shared a list of sample session agendas designed to help you build your personal SAS Global Forum 2015 schedule. But what if there are other areas of interest or topics you’d like to focus on? This is the first in a series of blog posts that

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonMarch 30, 2015 0

Paint it black: A song choice or a graph background?

This blog post discusses the use of a black background in a graph. But before we get started, I invite you to have a listen to one of my favorite songs - "Paint it Black" by the Rolling Stones. Perhaps this song subliminally persuaded people to use black backgrounds in

Read More

Programming Tips

Chevell ParkerMarch 27, 2015 0

Using SAS to add PivotTables to your Excel workbook

In Microsoft Excel, a PivotTable can help you to create an interactive view of summarized data. Within a PivotTable, it’s easy to adjust the dimensions (columns and rows) and calculated measures to suit your ad-hoc reporting needs. You can also create a PivotChart – similar in concept to a PivotTable, but

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonMarch 25, 2015 0

Spotting a misleading chart

Everyone loves a good conspiracy theory - hopefully you'll enjoy mine about the number of US E1 visas! I was perusing some of the US government charts, and found one on US immigration visas that caught my attention. It was a 3D bar chart, and since I always mistrust 3D

Read More

Analytics | Data Visualization | Programming Tips

Robert AllisonMarch 24, 2015 0

When art and analytics collide

The best graphs are both beautiful and informative - a smooth blend of art and analytics. But more often than not, the two collide rather than blending smoothly... Here is a link to a artistic infographic I recently saw posted by Vendavo on twitter. Their message (80% of your profit is generated

Read More

Data Visualization | Learn SAS | Programming Tips

Leonid BatkhanMarch 20, 2015 0

How to reverse graph axes in SAS Visual Analytics

It may never crossed your mind, but there are real-life cases when reversing graph axes make sense. For example, when Y-axis represents a depth under the sea level or depth of oil well drilling, it makes perfect sense to have zero on top and positive numbers increasing from top down.

Read More

Learn SAS | Programming Tips

Charu ShankarMarch 16, 2015 0

I can see clearly now thanks to this SAS student

With any software program, there are always new tips and tricks to learn, and nobody can know them all. Sometimes I even pick up tips or techniques from my students while they’re learning broader programming tips from me. Like fine wine, instructors only get better with age. Every customer interaction

Read More

Data Visualization | Programming Tips

Robert AllisonMarch 13, 2015 0

How to use the SAS pi constant

With Pi Day coming up on 3/14, I wanted to make sure all you SAS programmers know how to use the pi constant in your SAS code... All you have to do is use constant("pi") in a data step, and you've got the value of pi out to a good many decimal places

Read More

Programming Tips

Marjorie ShelleyMarch 13, 2015 0

Descriptive statistics—the more, the merrier in SAS Visual Analytics

This blog is not about the original movie The More the Merrier (1943) or its remake, Walk, Don’t Run (1966), which I’ve actually seen a couple of times. It’s actually about the wide variety of descriptive statistics available in SAS Visual Analytics—and when you want to examine the characteristics of

Read More

Previous 1 … 50 51 52 53 54 … 64 Next