[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
Category: SAS
Search tip for language elements
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…
Replace Missing Numeric Values using Missing Option/Proc STDIZE
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 …
COMPRESS: SAS Function strips characters from the string
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 …
SAS needs to fix Excel import for fields greater than 255 characters
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″;…
MMDDYY+: Format that inserts a slash, space or "-" between the date, month and year
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…
ERROR: The format XXXX was not found or could not be loaded.
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 …
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…