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 »

MMDDYY+: Format that inserts a slash, space or "-" between the date, month and year

February 10, 2010
By

Here is another new format which is available with SAS 9 version called MMDDYY+ . (MMDDYY+ format can insert colons /slash or periods etc between date, month and year values); This new date format developed by SAS works for many other formats, for ex...
Read more »

ERROR: The format XXXX was not found or could not be loaded.

February 7, 2010
By

Whenever you try to open a SAS data set which has permanent formats, you will get the error message in the log file saying “ERROR: The format XXXX was not found or could not be loaded.” This happens generally when you don't have the format ...
Read more »

SaviDataSet Alpha 1.0 On the Web

February 7, 2010
By
SaviDataSet Alpha 1.0 On the Web

I am finally ready with my SAS dataset reader/writer for .NET. It is written in 100% managed code using .NET 3.5. The dlls can be foundhere.A sample .NET console application can be found in the program file entries after the installation.Update 2/13/20...
Read more »

How to check how the dataset got sorted without looking at the code?

February 7, 2010
By

You can do this manually or programmatically. Manual Approach: Right click on the data set in the explorer and go to properties, then go to the details tab and see the sorted by values (Works only if you use Windows operating system) Programmatic ...
Read more »

SAS implementation of Kernel PCA

February 6, 2010
By

Kernel method is a very useful technique in data mining that is applicable to any algorithms relying on inner product . The key is applying appropriate kernel function to the inner product of original data space. I show here SAS/STAT+BASE ex...
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.