SAS gets your attention with a text message!

February 22, 2010
By

Contributed by Scott Vodicka, a member of the SAS Global Consulting Business Intelligence Practice An interesting topic came up the other day in one of my email conversations. What was the topic of the email? Well, I am glad you asked. It was how...
Read more »

An efficient macro for Stump – two terminal nodes tree

February 17, 2010
By

In this post, I post an improved SAS macro of the single partition split algorithm in Chapter 2 of "Pharmaceutical Statistics Using SAS: A Practical Guide" by Alex Dmitrienko, Christy Chuang-Stein, Ralph B. D'Agostino. The single part...
Read more »

Resources for creating a SAS stored process

February 16, 2010
By

Q: A customer wrote, "What, no stored process samples?" A: We do have samples and notes about writing and using stored processes. We do not have a browse topic for stored processes. Therefore, to find samples about creating and maintaining stored...
Read more »

Pivot tables and Cheezy Graphs? No more…

February 16, 2010
By

As any good analyst knows, working with data is not the problem. Good analysts have the skill necessary to combine, split, merge, slice, aggregate, or summarize data any way you can imagine. However, is that enough? Probably not.. What good does data do if you can’t communicate its meaning in a logical way. The...
Read more »

SAS Supplied Formats for SAS date 17750

February 15, 2010
By

]
Read more »

Search tip for language elements

February 14, 2010
By

If you are searching support.sas.com for documentation about a language element, include the word "syntax" in your search phrase. You do not need to include the phrase in quotes. For example, if you want a list of available formats or usage infor...
Read more »

Replace Missing Numeric Values using Missing Option/Proc STDIZE

February 12, 2010
By

MISSING OPTION Replacing missing values with the desired value like a zero is always a challenge, especially when we have a dataset with a number of columns to standardize. The OLD WAY of doing it to write a DATA step code with  ...
Read more »

COMPRESS: SAS Function strips characters from the string

February 12, 2010
By

In SAS 9.1.3 , an extra argument (MODIFIER) is added to the SAS character string function COMPRESS and these modifiers modifies the action of the COMPRESS function; Syntax: COMPRESS(<, chars><, modifiers>) ; Following characters can ...
Read more »

SAS needs to fix Excel import for fields greater than 255 characters

February 11, 2010
By

I have a spreadsheet where one column has character lengths ranging from 0 to 1000 or even more. Importing them has never been much of a problem with this code: PROC IMPORT DATAFILE="F:\path\to\file.xls"OUT=work.aDBMS=excel2002 REPLACE;SHEET="Sheet1";...
Read more »

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.