Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Chris Hemedinger

Chris HemedingerOctober 1, 2010 0

Export to Excel 2007/2010 using SAS Enterprise Guide

Since its 4.2 release, SAS Enterprise Guide has been able to import Microsoft Excel 2007 and 2010 spreadsheet files (usually encountered as .XLSX files). But while SAS Enterprise Guide can export XLS files (which are compatible with all versions of Microsoft Excel), it does not have the ability to export

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerSeptember 29, 2010 0

What to do IN BETWEEN dates

I saw a suggestion arrive from a SAS customer who would like to see the IN operator extended to allow ranges of date values. For example, you can currently write a program that checks for values IN a collection or range of numbers: data check; if x in (1:10) then

Read More

Programming Tips | SAS Events

Chris Hemedinger

Chris HemedingerSeptember 28, 2010 0

Get Smart!

AnnMaria wrote her latest blog post, "SAS Enterprise Guide makes you smarter", partly in response to my recent post about whether it's making you stupider. From the contents of her program example, I'm guessing that she's preparing for WUSS in November. I don't get to attend this year, but my

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerSeptember 16, 2010 0

A 64-bit success story: JMP

In my post yesterday about the 64-bit hype and how client apps like SAS Enterprise Guide would see only a limited boost from a 64-bit version, I forgot to point out another offering from SAS that has embraced the 64-bit architecture: JMP. JMP offers a 64-bit version, and it makes

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerSeptember 15, 2010 0

Should you care about 64-bit applications?

Question: Is there a 64-bit version of SAS Enterprise Guide? Answer: SAS Enterprise Guide is a 32-bit application, even with its most recent release. As such, it is still completely supported on any 64-bit Windows machine, but it runs in the 32-bit subsystem (also known as WoW64 – short for

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerSeptember 14, 2010 0

Is SAS Enterprise Guide making you stupid?

Have you ever visited a city for the first time and, instead of relying maps to plan your journey, you simply plug your destinations into a GPS device and mindlessly follow the navigation directions? You've just cheated yourself out of a learning opportunity, because planning the journey and using your

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerSeptember 1, 2010 0

Live long and prosper using PROC REG

The secret to long life is good genes, right? This publication titled "Joint influence of small-effect genetic variants on human longevity" showed up on my Google alerts, and from what I can read (all of it) and understand (very little of it), that assertion is true. The researchers used PROC

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerAugust 31, 2010 0

SAS Enterprise Guide 4.3 is available

Shane and others have already discovered this. The new version of SAS Enterprise Guide is now available. The latest version offers tremendous enhancements for all users, especially SAS programmers. It includes a new SAS program editing environment that supports syntax suggestions and autocomplete, embedded syntax reference help, and a SAS

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerAugust 10, 2010 0

Talking in my sleep

I've completed my first day of teaching a two-day course about SAS Enterprise Guide. I'm in Sydney, Australia...but my biological clock is still tuned into Cary, North Carolina time. I woke up at 1 a.m. today and even though I tried to convince my body that it was still time

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerAugust 3, 2010 0

A winter term at Hemedinger U.

I received this offer in the post the other day: "University apparel just for you, featuring the name HEMEDINGER!" Yes, the offer has it correct. This would be just for me, because I can't think of anyone else who might order it. I regret that I didn't receive the offer

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJuly 26, 2010 0

Job security through code obscurity

Art Carpenter offers tremendous advice to SAS programmers who want to maximize their job security: make your programs impossible for others to read and understand. In his published papers, Art (in his tongue-in-cheek manner) presents practical examples for how to accomplish this. I'm afraid that with our new code formatter

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJuly 14, 2010 0

Hope for ugly programs

Have you ever inherited a SAS program from a "gifted" SAS programmer? By "gifted", I mean a person who regards line feeds and white space as a waste of precious bytes, who knows that his program is worth the tremendous effort it might take to read and understand it, as

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJuly 12, 2010 0

Using Gmail to send a message via SAS Enterprise Guide

You can use SAS Enterprise Guide to automate most aspects of queries, analytics, and reporting -- including sending e-mail notifications with the results. In this blog post, I'll show you how you can send these results and use Gmail as your e-mail provider. First, some background: SAS Enterprise Guide provides

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJune 28, 2010 0

Thinking economically

As I mentioned in a recent post, I've just completed reading Dear Undercover Economist by Tim Harford. I acquired a copy of Tim's book at the SAS Professionals Convention, and I was fortunate enough to meet Tim in person and have him sign the book. He impressed me as very

Read More

Programming Tips

Kirsten HamstraJune 24, 2010 0

The Ultimate Set for SAS DATA Step Programmers

Are you a SAS DATA step programmer? If so, be sure to take advantage of this exclusive "buy 2 books, get 1 free" offer from SAS Publishing. Solutions for SAS Data Step Programmers: The Essential Three-Book Set of Examples from Michele Burlew features 3 of her most popular books, including:

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJune 11, 2010 0

Let's call the whole thing off

What do you do when you and your spouse are both SAS users, but one of you likes to point-and-click and the other really likes to write SAS programs? Is it possible to share a SAS environment, or are these irreconcilable differences that can lead only to a nasty custody

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerJune 9, 2010 0

Crayon guide to DATA step merges (and other links)

I'm using this post to share links to several SAS-related blogs created by others. This is me acting generous by sharing -- it's not me acting lazy by shirking an original post. Really. Datum Reparo! AnnMaria waves her SAS Enterprise Guide magic wand, utters a few (magic?) words, and makes

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMay 25, 2010 0

Reporting on SAS Information Maps

Like any good SAS professional, I subscribe to the SAS Samples RSS feed. The other day I found this sample that shows how to create a PDF report about the contents of a SAS Information Map. It's a nice example: it shows how to use the INFOMAPS engine and ODS

Read More

Programming Tips

Mike KaltMay 25, 2010 0

SAS/GRAPH "SG" Procedures--Not Just for Statisticians!

If you are a SAS/GRAPH user, you may have heard about the new Statistical Graphics ("SG") procedures that are new in SAS 9.2. These procedures are designed to make it easier to produce common statistical charts and plots. You may have assumed that the procedures are only for folks who

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMay 24, 2010 0

Finding the FOREIGNers in your SAS environment

As Shane reveals on his blog, your SAS session is equipped to read data that are encoded for all types of machine architectures and locales. ASCII, EBCDIC, 32- or 64-bit, English, Japanese, Greek, Hebrew: the list goes on and on. SAS accomplishes this by using a feature called Cross-Environment Data

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMay 18, 2010 0

Getting out of SORTs with SAS data

Why does this SAS program produce an error? proc means data=sashelp.cars mean median min max; by origin; run; It's because SASHELP.CARS is a SAS data set, and SAS data sets observations are stored and processed sequentially, and a BY group operation requires that the observations are already grouped and sorted

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMay 10, 2010 0

Viewing SAS catalogs from SAS Enterprise Guide

SAS catalogs have been around for a long time. Not quite as long as the Sears or L.L. Bean catalogs, but SAS customers have used catalogs to store and retrieve content for many years. A SAS catalog is a special type of SAS file that acts as a container, like

Read More

Programming Tips

Michele ReisterMay 7, 2010 0

It’s the added value that counts

Welcome to SAS Training Post, the official blog of SAS Training & Certification! My name is Michele Reister and I am the social media manager for SAS Education. This blog will be a channel to provide you with value-add educational content to help you be a better SAS user. You’ll

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMay 7, 2010 0

Keeping historical versions of output from SAS Enterprise Guide

This is the topic of an 8-minute video tip from SAS Education. What's great about this tip: not only does it show you how to keep historical versions of reports and data that you create in your projects, but it also provides a nice example of cross-tab reporting in SAS

Read More

Programming Tips

Waynette TubbsApril 13, 2010 0

5 Things to Make you a More Organized SAS® Programmer

Jean Balent gave a quick 20-minute presentation of her ideas that may help programmers become more organized and therefore more productive. The presentation is a shortened version of her paper, How to become an organized SAS programmer. In fact, her tips may be useful in other areas of your career.

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerApril 5, 2010 0

In the year 9999...

...if man is still alive, will he be importing Excel spreadsheets and wondering why his leap years are off? I received this report from SAS Technical Support, on behalf of a customer who uses SAS Enterprise Guide to import spreadsheet data: The date "12/31/9999" will import as "02Jan****" when reading

Read More

Programming Tips

Christine KjellbergMarch 26, 2010 0

Two and Half Lost Concepts

As Stacey mentioned in her last blog post, she’s a fan of the television show Lost, as I am too. Often our final few minutes of study group will discuss the numerous theories regarding the Lost castaways and their island stories and sideways stories. For 5 minutes or so, it’s

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMarch 15, 2010 0

Multiple identities: for all of the people you are

When you connect to a SAS environment with SAS Enterprise Guide, are you a single, consistent person? Or do you have more identities than Chevy Chase in Fletch? When you connect to a SAS environment, you can be many people at once: You are logged into your Windows account on

Read More

Programming Tips

Christine KjellbergMarch 5, 2010 0

Programming Efficiency

In one of my previous posts, I challenged myself to use SAS to create a monthly household budget and I’m happy to report that I have started this process. I have a few months worth of data and have begun to merge this information into data sets. With the combination

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMarch 3, 2010 0

SAS: The . Manual

Check out AnnMaria's blog covering what she's learned by being on the bleeding edge: using SAS 9.2 for Windows x64 on a Win7 virtual machine. Also, her short primer on XPT files makes me want to add some native capability into SAS Enterprise Guide. If your goal is to send

Read More

Previous 1 … 61 62 63 64 65 Next