Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Learn SAS | Programming Tips

Andy RavennaJanuary 30, 2013 0

An easy way to find variables in common to data sets

Over the holidays I was having a discussion with my cat, Ms. Trixie Lou. A question that often arises during the first programming class is the following: how do I find the variables that are in common to these two or three data sets? As it turns out, Ms. Trixie

Read More

Programming Tips

Casey ThompsonJanuary 28, 2013 0

SAS and Windows 8

Windows 8 was officially released Friday October 26. This was Microsoft’s first operating system release since the introduction of Apple’s iPad and the subsequent surge in popularity of tablets. To align their OS with the new computing devices, Windows 8 has two interfaces to allow access from traditional desktops and laptops and

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJanuary 25, 2013 0

How to search your SAS Enterprise Guide projects

Last year I published an example application for searching your SAS Enterprise Guide project files (EGP files). The example shows off some of the cool features of the automation API, and it's a useful tool. As neat of an example as that was, it had some limitations. It worked only

Read More

Data Visualization | Programming Tips

Click New for Output Parameters

Angela HallJanuary 21, 2013 0

Maintaining prompt selections in multiple Web Report Sections (v4.3)

SAS Technical Support has a wonderful how-to guide for using one set of prompt values across multiple sections of a Web Report Studio report. This works great in 4.2, however there is one additional item that I discovered in a 4.3/9.3 install. With the addition of PROC STP and SAS

Read More

Data Visualization | Programming Tips

Robert AllisonJanuary 17, 2013 0

A neat new trick to trim your macro variables in 9.3

SAS macro variables are a great way to store a calculated value, so you can use it later in your code. They are not just limited to the data step -- you can also use macro variables in title statements, axis statements, etc. By default, the macro variable will be padded with

Read More

Data Visualization | Programming Tips

Robert AllisonJanuary 9, 2013 0

How to handle percent (%) values in SAS

Being that 2013 is the International Year of Statistics, I wanted to make sure everyone knows how to handle my favorite statistic - percent (%) - in SAS! I often see data in spreadsheets/csv/etc that purport to represent "percents"... but you have to be a bit careful when working with

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJanuary 7, 2013 0

Controlling access to custom tasks in SAS Enterprise Guide

I've bragged about how easy it is to install custom tasks for SAS Enterprise Guide. It's simple: you copy the .NET assembly (usually a single DLL file) into one of the designated folders in your SAS Enterprise Guide installation, and your task just shows up in the menu. Since I

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJanuary 4, 2013 0

My favorite SAS tips and tools from 2012

Many of my blogging colleagues are taking this week to reflect on their top posts in 2012. Some are using the visitor statistics to rank the posts, but as Andy Ratcliffe points out, that gives short-shrift to the late-season articles. This year, I'm going to use this space to recap

Read More

Learn SAS | Programming Tips

Charu ShankarDecember 20, 2012 0

3 gifts to magically transform your data

‘Tis the season to be gifting! So what could be better than gifting your fellow SAS user or yourself with three gifts to celebrate the holiday season? As 2012 comes to an end, we think it’s a great idea to be thinking of ringing in the New Year with dynamic

Read More

Programming Tips | SAS Administrators | SAS Events

Waynette TubbsNovember 20, 2012 0

Tune your SAS system for max performance

Kirk Paul Lafler, Software Intelligence Corporation, has written four SAS books and more than 500 peer-reviewed papers - 19 of which were awarded Best Contributed Papers or Poster, so I’m going to believe him when he says that he’s figured out a thing or two about tuning SAS systems.

Read More

Learn SAS | Programming Tips

Charu ShankarNovember 14, 2012 0

Next best thing since sliced bread - SAS Enterprise Guide

I recently had a student in a SAS Enterprise Guide class declare that EG was the next best thing since sliced bread. I couldn't have agreed with her more! In this post, I‘ll share four ways where EG outperforms SAS code –yes I know you’re a codeaholic dear reader, but these reasons

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerNovember 9, 2012 0

Using a SAS function to validate a National Provider ID (NPI) value

We are careening towards the holiday season, and this year more than ever before it's going to mean one thing: Online Shopping. As you enter your credit card number over and over to complete your many purchases, you might occasionally transpose or mistype your account number. Does it surprise you

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallNovember 5, 2012 0

Cleaner OLAP cube physical folder structures

Each spring and fall, I start clearing out the kid's small clothes, old toys, etc. It can sometimes go too far and reach into my "digital pack-rat" issues. (Wait, what does that mean? Well, just ask the person who last week requested detail on a project I worked 3 years

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerOctober 29, 2012 0

Using source control management with SAS Enterprise Guide

I work on a variety of projects at SAS, most of which require some level of team collaboration in source management systems. Due to the many technologies that we work with, SAS developers use different source management tools for different purposes. I've got projects in CVS, Subversion, and Git. When

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallOctober 29, 2012 0

So many autoexecs; three tips for BI administrators

BASE SAS users are already familiar with the autoexec file. This is a .sas file that typically resides in the installation folder of the SAS executable. Instructions for setting it up in UNIX, Windows, and other environments is readily available on the SAS website. In SAS BI configurations there are

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallOctober 22, 2012 0

Verifying a SAS BI installation

After installing SAS Business Intelligence, I would also suggest verifying that all is working appropriately before adding users or importing content from another machine. (My template checklist is included below.) The act of creating the content is an extremely important test (to immediately rectify issues with accessing data, or saving

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerOctober 19, 2012 0

Creating a somewhat unique ID using the UUIDGEN function

According to the Daily Writing Tips blog, describing a thing as "somewhat unique" is bad form. Unique means "one of a kind", so either it is or it is not. The famous example (which the style police will use to chide you) is that you can't have something as "somewhat

Read More

Learn SAS | Programming Tips

Lise CragenOctober 17, 2012 0

Encore! Encore! The SAS Training Roadshow continues

Program update for 2013! The SAS Training Roadshow is back on tour. This year, we’re heading out to six rockin’ cities. We’d love to see you there. Cleveland - St. Louis – Portland - San Jose - Indianapolis - Las Vegas. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ In my previous post, I revealed my top

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallOctober 15, 2012 0

Go on a date with SAS BI Dashboard, part 2

Last week I provided the steps for how to go on a date, at least by using dynamic prompts in BI Dashboard. Now that you have seen how to create them, lets discuss making them smarter. For this example, the customer is asking for two prompts to affect a single

Read More

Programming Tips

Lise CragenOctober 10, 2012 0

On the Roadshow again

Program update for 2013! The SAS Training Roadshow is back on tour. This year, we’re heading out to six rockin’ cities. We’d love to see you there. Cleveland - Portland - San Jose - Indianapolis ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ As I prepare for my stint on the SAS Programming "Roadshow," it occurs to

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerOctober 9, 2012 0

Special automatic macro variables available in SAS Enterprise Guide

You might know about the many automatic macro variables that are available in SAS. They provide plenty of information about the SAS environment, such as the current user (SYSUSERID), the SAS version (SYSVER and SASVLONG), and the operating system where SAS is running (SYSCP and SYSCPL). That information is often

Read More

Advanced Analytics | Data Visualization | Programming Tips

Angela HallOctober 8, 2012 0

Go on a date with SAS BI Dashboard, part 1

Don't give up on the dating game. Just because there is no prompt type specifically for dates, it can still be accomplished with some stored process matchmaking. BI Dashboard offers a dynamic prompt indicator which provides the ultimate flexibility in developing prompt based reports and dashboards. The dynamic prompt indicator

Read More

Programming Tips

Robert AllisonOctober 5, 2012 0

Custom SAS graphs = competitive advantage

SAS/GRAPH gives you the ability to customize your graphs (or even create totally new types of custom graphs) ... and it is my firm belief that it gives you a competitive advantage by allowing you to "make sense" of your data in ways your competitors can't. Most of the examples in

Read More

Learn SAS | Programming Tips

Charu ShankarOctober 1, 2012 0

Three must have SAS freebies

"I want everything!" said a student when I paused to ask my SAS Programming 1 class what else they wanted to learn. Seriously! You want me to share everything I know in three days? The student came back with... "Well okay, what about those freebies you mentioned?" That’s how it all

Read More

Programming Tips

Robert AllisonSeptember 26, 2012 0

Adding pop-up graphs to your SAS/GRAPHs

By now, most of you probably already know how to add drill downs and hover text to your SAS graphs. But did you know you can add pop-up images and graphs? Here are a couple of examples ... In this first example, when you hover your mouse over each state, you

Read More

Programming Tips

Miss SAS AnswersSeptember 19, 2012 0

Selecting the Second Duplicate Observation

Dear Miss SAS Answers, I have read through a few Dear Miss SAS Answers blog posts, but I cannot seem to find what I am looking for. I need to extract only the second duplicate from a whole list of duplicates per account number. Is there a way to

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerSeptember 18, 2012 0

HAVING (clause) fun with SAS Enterprise Guide

Last week I attended a meeting of the Toronto Area SAS Society. (Okay, I didn't just attend; I was a presenter as well.) This user group meeting contained a feature that I had never seen before: "Solutions to the Posed Problem". Weeks before the meeting, an "open problem" was posted

Read More

Data Visualization | Programming Tips

Robert AllisonSeptember 18, 2012 0

It be "International Talk Like a Pirate" day - Arrr!!!

Avast Mateys! Did you know that International Talk Like a Pirate Day is coming up?!? (September 19) Here's the official website, if you'd like more info. And what better way to get into the spirit of things than to use SAS/GRAPH to plot some real pirate data - Arrrr!!! Here's

Read More

Data Visualization | Programming Tips

Angela HallSeptember 17, 2012 0

Always learning something new, two awesome Enterprise Guide tricks

Who says anyone is an expert at something? I definitely do not when it comes to SAS (well, anything for that matter). Each time I sit through a presentation at a conference I learn something new. During the SAS Western Users Conference, fondly know as WUSS, this month I learned

Read More

Previous 1 … 54 55 56 57 58 … 65 Next