Tag: formats

Using formatted CLASS variables

If you use formatted variables in a CLASS statement in procedures such as MEANS or UNIVARIATE, SAS will use the formatted values of those variables and not the internal values. For example, consider you have a data set (Health) with variables Subj, Age, Weight, and Height. You want to see […]

Using formatted CLASS variables was published on SAS Users.

Fun with Ciphers (Part 2)

In my previous blog, you saw how to create a Beale cipher. In this blog, you will see a program that can decode a Beale cipher. As a reminder, here is a list of numbers that you can use as a substitute for a letter when creating your cipher. Now, […]

Fun with Ciphers (Part 2) was published on SAS Users.

Viewing SAS catalogs and formats in SAS Enterprise Guide

Many years ago I shared a custom task that allows you to view and manage SAS catalogs within SAS Enterprise Guide. As a reminder, a SAS catalog is a special type of SAS file that acts as a container, like a folder, for a variety of content items called catalog […]

The post Viewing SAS catalogs and formats in SAS Enterprise Guide appeared first on The SAS Dummy.

The data behind jail breaks

You’ve probably seen headlines about the recent jail break in California. Do you think they’ll catch those guys? Is there any data available about recapturing escapees? You betcha! … And do they need some help graphing that data? It appears so! But before we get started on the graphs, here’s […]

The post The data behind jail breaks appeared first on SAS Learning Post.

Why should we teach Roman numerals?

In my local paper this morning, I read about how a North Carolina state commission plans to recommend changes to our teaching standards for mathematics. One of the topics that they want to bring back: Roman numerals. Why? According to my exhaustive 30 seconds of Internet research, the only practical […]

The post Why should we teach Roman numerals? appeared first on The SAS Dummy.

Numbers great and small: the problem of Big Datum

About once a month, a customer approaches SAS and asks a question of significance. By “significance”, I don’t necessarily mean “of great importance”, but instead I mean “of how SAS handles large numbers, or floating-point values with many significant digits”. In response, we always first ask why they asked. This […]

Just-in-time data prep in SAS Enterprise Guide

On this blog, I’ve delivered a few tips about using SAS formats to stratify your data values “in place” without having to actually change your data. The most recent example addressed date and datetime variables. My previous examples included simple SAS programs that you can run in SAS display manager […]

SAS Info Map: Need leading zeros on the account number?

When creating new variables, the SAS Information Map Studio opens the entire SAS format library to you.  These formats can be key to creating lots of new data items.  SAS format control the way data items appear.  In past articles I showed you how to create new data item using SAS functions and date formats. Check the SAS documentation to learn more about all the different formats available. Creating new Data Items in SAS Information Map Studio When data has been merged from various companies, such as when one company acquires another one, their data may be in different formats.  For instance, account numbers might vary from 8 characters in one company and 12 characters wide in the other. When this occurs one option is to use the widest account number and add zeros to the front of the smaller one to integrate the fields better.  You can do this easily within the information map using the Z format.   From SAS Information Map Studio, you can create or modify the existing variable.  In this case I have two account numbers – 1 where there are only 3 characters and the other with 5 characters. The end result should be […]