Profile cover photo
Profile photo
Michael Raithel
35 followers
35 followers
About
Michael's posts

Post has attachment
The Little SAS Program's BIG Night Out
The little SAS program’s
official name was Extract_Transform_Load_ 0314.sas .  But, that name
was much too formal, way too long, and did not roll off of the tongue very
easily at all.  So, everybody simply called her:  ETL Pi. ETL Pi was conceived in a
2-ho...

Post has attachment
Hack 4.19 Up-Coding Text Variables with the VVALUE Function
SAS Programming Professionals, Did you know that you can use a SAS format to up-code text
variables based on a numeric response variable? The
VVALUE function returns a character value that
is the results of bouncing a numeric
variable’s value against a form...

Post has attachment
Hack 4.18 Up-Coding Text Variables with the CHOOSEC Function
SAS
Programming Professionals, Did
you know that you can use a SAS function to up-code text variables based on a
numeric response variable? The
CHOOSEC function returns a
character value that represents the results of choosing from a list of
arguments based...

Post has attachment
Hack 4.17 Sorting Variables Within an Observation
SAS Programming Professionals, Did you know that you can sort the values of variables within an observation into ascending order?  The SORTN CALL routine allows you to do just that.  Here is an example: options nodate nonumber ; /* Create the Test data set*...

Post has attachment
Hack 4.16 Simplifying IF/THEN/ELSE Statements Using the IFC and IFN Functions
SAS
Programming Professionals, Did
you know that the IFC and IFN functions allow you to have 1-line
IF/THEN/ELSE-like statements?  The
IFC and IFN functions can be handy when you have a single THEN condition and a
single ELSE condition and you would like to...

Post has attachment
Hack 4.15 Setting Multiple Variables to Missing in a Single Statement
SAS Programming Professionals, Did you know that you can easily set one or more SAS
variables to missing values in a single statement? The CALL Missing SAS call routine allows you to set
character and numeric variables to missing values.  Call Missing sets
...

Post has attachment
Hack 4.14 Running System Commands from a SAS Program
SAS Programming Professionals, Did you know that you can execute Windows operating
system commands from within a SAS Data step? You can do this by using the CALL SYSTEM call
routine.  Unlike its blunt cousin the X
statement, CALL SYSTEM can be executed cond...

Post has attachment
Hack 4.13 Reversing Character Strings with the REVERSE Function
SAS
Programming Professionals, Did
you know that: the REVERSE function can be very useful and also a lot of fun to
use? The
REVERSE function can be used to return a character string in reverse
order.  For instance, consider the
following example: data testi...

Post has attachment
Hack 4.12 Renaming Files and Directories from A DATA Step
SAS Programming Professionals, Did you know that you can rename SAS data sets, SAS catalog entries, as
well as OS directories and files in directory-based operating systems from inside of a SAS DATA step?  The RENAME function lets you do exactly that!  It i...

Post has attachment
Hack 4.11 Removing Leading and Trailing Blanks with the STRIP Function
SAS Programming Professionals, Did you know that there is a function that will
effortlessly strip off leading and trailing blanks from a
character variable? The aptly named STRIP function allows you to do just that
and is a great replacement for the old TRI...
Wait while more posts are being loaded