Tag Archives: SAS Programming

The today() function of SAS programming is basically used to generate current date. The format() function is used to display the format of the date… Read More »

Generally, when we import data from external sources such as Excel/CSV files, it loads additional rows that are totally blank. Sometimes empty values in the… Read More »

The COALESCE function is employed to pick the first non-missing value in a list of variables. In other words, it returns the first non-blank value… Read More »

COMPRESS function is basically used to compress/removes all the spaces/blanks in a character string. In other words, it removes leading, between and trailing spaces from… Read More »

Informats is used to tell SAS how to read a variable whereas Formats is used to tell SAS how to display or write values of… Read More »

The WHERE statement is a substitute to IF statement when it comes to subsetting a data set. Syntax: WHERE (condition is true) => It refers… Read More »

Entering Data Directly: You can enter numbers of lines of data directly in SAS program by using a DATALINES statement. The keywords are as follows:… Read More »

Comparison Operators used while using conditional statements. Symbol Mnemonic Meaning = EQ equals ^= or ~= NE not equal > GT greater than < LT… Read More »

This topic is regarding how to drop variables from a dataset in SAS. It includes various methods to delete variables from data. In SAS, there… Read More »

LIKE Operator: Pattern Matching The LIKE operator used to select data by comparing the values of a character variable to a specified pattern. It is… Read More »

IS MISSING Operator: Selecting Missing Values Task 1: Suppose you want to select only those observations in which students did not fill their section information.… Read More »

PROC IMPORT: It is a procedure to import external files into SAS. It automates importing process. There is no need to specify the variable type… Read More »

Suppose you have a list of variables. You don’t want to type the name of each variable every time to define them within the function… Read More »

BETWEEN-AND Operator: Between Two Numbers Task 1: Suppose you want to select scores whose values are greater than or equal to 50 and less than… Read More »

This will help you to create or modify a variable. It is common to define a new variable based on the existing variable. Let’s create… Read More »