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
Tag Archives: SAS Programming
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