SAS Learning Post

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Angela HallNovember 9, 2011 0

Limit the number of drill-through to detail records available from OLAP cubes

Drill-through to detail is the ability to right click within a cell of a web report or OLAP viewer and request the detail source records that make up that specific cell's measure. The maximum number of records, by default, is set to 300,000. Feasibly the report user could download all

English

Data Visualization | Programming Tips

Angela HallOctober 27, 2011 8

Revisiting the starting file location for Enterprise Guide

Years ago and a seemingly far galaxy away, I wrote about how to modify 9.1.3 to start Enterprise Guide users in a different location for the File folder. By default, the user only can access their personal SAS Temporary File. Why change this? I would prefer to use a central

English

Advanced Analytics | Data Visualization | Programming Tips

Angela HallOctober 18, 2011 12

Troubleshooting a web file upload

Functionality to upload files onto the SAS server (from 9.2 on) is available using stored processes and an html input type="file". I introduced this topic last year in my blog post using the SAS Stored Process Developer Guide sample. Of course, it is never as easy as the sample is

English

Learn SAS | Programming Tips

Charu ShankarOctober 12, 2011 13

Bad words in SAS - PG rating

Picture this – a student grabs the Programming 1 textbook, scans it quickly seemingly searching for something specific, and shakes his head indicating an unsuccessful search. He plants himself smack dab in the front row, looks me squarely in the eye, raises one eyebrow quizzically and says, “Bad words?” I

English

Learn SAS | Programming Tips

Charu ShankarJune 21, 2011 8

Is something missing or is it a ZERO?

As far as numbers go, the number zero is rather mysterious for data. Is it something or is it nothing? What happens when you have missing data but enter 0? This topic triggered an intriguing discussion in my recent Programming 2: Data Manipulation Techniques class. In this post I’d like

English

Learn SAS | Programming Tips

Charu ShankarMarch 30, 2011 7

SAS Programmer Rule # 1

Let’s start with a quiz. Which of the following is the Programmer’s Rule # 1? 1. Expert knowledge of multiple languages, like SAS and Java 2. Talent to maneuver with complex algorithms 3. Innate ability to draw flowcharts 4. None of the above Dear reader, as a savvy programmer, you

English

Learn SAS | Programming Tips

Charu ShankarFebruary 23, 2011 23

Top 5 SAS programming best practices

I’m sure you will all agree that a programmer’s favorite task is to maximize efficiency thus enhancing performance. Dear reader, in this blog post I’ll share my best programming practices so that you can benefit from what I typically show my students in class. At the end I’d like to

English

Learn SAS | Programming Tips

Charu ShankarJanuary 24, 2011 5

Find your data pattern with Perl

Who doesn’t like bargains? I’m sure you will all agree that good quality at a next-to-nothing cost is irresistible. My recent Dollarama run had me ecstatic about the gloves that come in all colours, styles and sizes for just over a dollar. (Fact: big retail stores charge over 10 times

English

Learn SAS | Programming Tips

Charu ShankarDecember 17, 2010 21

Five reasons to use the SAS DATA Step or PROC SQL

When I joined SAS Institute I had no knowledge of SAS. I studied, researched and practiced. The questions I asked would make even the most seasoned programmer blush a beetroot red! Those were an intense nine months—I’ll tell you more in a later post about the learning system at SAS

English

Programming Tips

Catherine (Cat) TruxilloDecember 2, 2010 5

Weekday Morning Quick-trick: How to Score from PROC VARCLUS

Have you used multivariate procedures in SAS and wanted to save out scores? Some procedures, such as FACTOR, CANDISC, CANCORR, PRINCOMP, and others have an OUT= option to save scores to the input data set. However, to score a new data set, or to perform scoring with multivariate procedures that

English

Blogs

Blogs

Programming Tips