SAS Blogs

Programming Tips

Chevell ParkerApril 20, 2021 0

Creating a report that displays only the column headings for a data set containing 0 records

This blog demonstrates how to create a report that provides only the column headings for data that is missing. The blog also explains how to create, select, and exclude output objects as well as how to generate reports with the SAS® Output Delivery System (ODS). These concepts are relevant to the task of generating a report with the column headings for a data set that contains no (0) observations.

English

SAS Administrators

Gregory NelsonMarch 6, 2013 0

Seeing SAS data through metadata

Last time we discussed the fundamentals of SAS data and how we reference that data in SAS Foundation. Now, we will turn our attention to how you access and protect data when you want to expose data through SAS clients versus the traditional LIBNAME method.

English

SAS Administrators

Gregory NelsonFebruary 20, 2013 0

Data by any other name

So let’s get down to it, what exactly do we mean by data in SAS? We hear all about “big data”, tiny data, datasets, metadata, OLAP, relational data, but what do I really need to know when it comes to SAS?

English

Chris HemedingerJanuary 21, 2013 0

Turn your data set into a DATA step program

Sometimes I need to "disassemble" a SAS data set into a DATA step program. It's kind of like creating a "freeze-dried" version of the data that you can carry around and use anywhere, re-hydrating it in the SAS session where you next need it. Some example uses for this: Build

English

Programming Tips

Chris HemedingerAugust 15, 2012 0

Comparing data set schemas in SAS

The project that I'm currently working on requires several input data tables, and those tables must have a specific schema. That is, each input table must contain columns of a specific name, type, and length in order for the rest of the system to function correctly. The schema requirements aren't

English

Chris HemedingerMay 9, 2012 0

Using Windows PowerShell to view your SAS data dictionary

In a previous post I showed how you can use Windows PowerShell (with the SAS Local Data Provider) to create a SAS data set viewer. This approach doesn't require that you have SAS installed, and allows you to read or export the records within a SAS data set file. In

English

Chris HemedingerApril 12, 2012 0

Build your own SAS data set viewer using PowerShell

In about 30 lines of PowerShell script, we can build a SAS data set viewer that: Does not require SAS on the PC Provides very basic filtering capability Also allows for easy export to CSV All you need is the ability to run PowerShell scripts, and the SAS Local Data

English

Advanced Analytics

Waynette TubbsSeptember 30, 2011 0

Friday's Innovation Inspiration - SASS

I used to get an email with a joke in it every Friday from my former boss, he called it Friday's Funnies. Some were really funny. Some - not so much. Well, I've decided to start my own Friday treat - a new series - called Friday's Innovation Inspiration. I'll be using

English

Programming Tips

Waynette TubbsSeptember 12, 2011 0

Be the brightest light on the porch: Efficiency tips for programmers

Kathleen Harkins, Carolyn Maass and Mary Anne Rutkowski, from Merck Sharp and Dohme, collaborated to write T.I.P.S: Techniques and information for programming in SAS® for NESUG 2011. These three women are highly experienced programmers: Harkins has more than 20 years of experience in the pharmaceutical and aerospace industries; Maass has

English

Programming Tips

Chris HemedingerNovember 16, 2010 0

Look before you buy: peek at your data details before opening

Are you afraid of big commitments? Do you like to shop around thoroughly before making a purchase decision? I can't help you with most of Life's Big Choices, but I can help you in one way: I can show you how to learn more about your data set before you

English

Blogs

Tag: data sets