Posts Tagged ‘ sas press ’

How to perform an operation on all numeric or all character variables in a SAS data set

June 27, 2017
By

In a previous blog, I demonstrated a program and macro that could identify all numeric variables set to a specific value, such as 999. This blog discusses an immensely useful technique that allows you to perform an operation on all numeric or all chara...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off on How to perform an operation on all numeric or all character variables in a SAS data set

Keeping your data set clean: Integrity constraints

June 26, 2017
By

When I teach my Data Cleaning course, the last topic I cover in the two-day course is SAS Integrity Constraints.  I find that most of the students, who are usually quite advanced programmers, have never heard of Integrity Constraints (abbreviated ICs).  I decided a short discussion on this topic would

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Keeping your data set clean: Integrity constraints

Using regular expressions to verify the pattern of character data

June 6, 2017
By

Wait!  Don't close this window.  I understand that regular expressions can be very complicated (yes, there are many books on the subject), but some basic expressions to test patterns such as zip codes or telephone numbers are not that difficult.  In addition, you can sometimes use Google to search for

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Using regular expressions to verify the pattern of character data

How to control the name of Excel sheets when they are all created at once

April 18, 2017
By

Ok, so you know how to create multiple sheets in Excel, but can anyone tell me how to control the name of the sheets when they are all created at once? In the ODS destination for Excel, the suboption SHEET_INTERVAL is set to TABLE by default.  So what does that

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on How to control the name of Excel sheets when they are all created at once

What’s your SAS interface?

April 12, 2017
By

I recently asked a SAS user, “Which interface do you use for SAS?” She replied, “Interface? I just install SAS and use it.” “You’re using the SAS windowing environment,” I explained, but she had no idea what I was talking about. This person is an extremely sophisticated SAS user who

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on What’s your SAS interface?

Capturing output from any procedure with an ODS OUTPUT statement

March 31, 2017
By

There's an old song that starts out, "You Can Get Anything You Want at Alice's Restaurant."  Well, maybe you are too young to know that song, but if you’re a SAS users, you’ll be glad to know that you can capture anything produced by any SAS procedure (even if the

The post Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on Capturing output from any procedure with an ODS OUTPUT statement

Reuse a Graph with Different Data

March 13, 2017
By

This post is from SAS Author Sanjay Matange. It's part of our SAS Author Tips series. Do you have a complex multi-cell graph created in ODS Graphics Designer that you’d like to reuse with different data? Ideally, you’d like to change the data without having to change the plots in each cell. The

The post Read more »

Tags: , , ,
Posted in SAS | Comments Off on Reuse a Graph with Different Data

Free SAS resources that every SAS user should know about

February 28, 2017
By

Whether you are just getting started with SAS or an experienced user there are a slew of free resources you should know about. First, you can download and learn SAS for free. SAS University Edition is available for anyone who wants to learn SAS. Additi...
Read more »

Tags: , , ,
Posted in SAS | Comments Off on Free SAS resources that every SAS user should know about

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.