Most people use Excel to make financial calculations. But SAS is also very capable of helping in…

There are multiple logarithmic functions available to determine the log of a variable in SAS. The most used log functions are the natural and common log functions.

The code illustrates how to append records to an existing file in SAS. It can be used to add text to the bottom of an existing file with the MOD option in the FILE statement.

To Generate all permutations of elements in SAS, use the FACT function then determine the permutation using the CALL ALLPERM.

Here is an example of a code that you can use to copies a file byte by byte. It copies the content byte-by-byte so it can be used to copy any file, even pictures! This will work on both Unix and Windows and it's great for copying files from your SAS session to a place outside of SAS, or vice versa.

To delete labels and format from a variable, use the PROC DATASET  procedure and attrib statement.

For the past few years, I've been learning SAS and have found that most of the functions I use are…

In the example dataset - SASHELP.HEART, you want to create a new variable - Activity_status and assign one of three values of ('High', 'MEDIUM', 'LOW'), at random to each observation. You can achieve these using 2 methods. Method 1: Using an array data heart(drop=id _1-_3 keep=status sex bp_status chol_status activity_status); set sashelp.heart(obs=10); array _{3} $ [...]

This program will change the case for all of the character variables in a SAS data set. The key here is using the _CHARACTER_ keyword in the ARRAY statement. This will create an array of all the character variables in the dataset.

Removing dashes and parentheses from phone numbers is one of the common data cleaning activities. This program uses the compress function to remove unwanted characters from a phone number.