SAS operator

Operators in SAS are symbols used in mathematical, logical, or comparison expressions. These symbols are built into the SAS language, and many operators can be combined in a single expression to give the final output.

The following is a list of SAS operator categories.

• Arithmetic operator
• The logical operator
• Comparison operator
• Min/Max operator
• The connection operator

Let's look at it one by one. Operators are always used with variables that are part of the data analyzed by the SAS program.

Arithmetic operator

The following table describes the details of the arithmetic operator. Let's assume that the two data variables V1 and V2 have values of 8 and 4, respectively.

Cases

DATA MYDATA1;
input @1 COL1 4.2	@7 COL2 3.1; 
Add_result = COL1+COL2;
Sub_result = COL1-COL2;
Mult_result = COL1*COL2;
Div_result = COL1/COL2;
Expo_result = COL1**COL2;
datalines;
11.21 5.3
3.11  11
;
PROC PRINT DATA=MYDATA1;
RUN;

After running the above code, we can get the output below.

The logical operator

The following table describes the details of the logical operator. T hese operators evaluate the True value of the expression. Therefore, the result of the logical operator is always 1 or 0. Let's assume that the two data variables V1 and V2 have values 8 and 4, respectively.

Cases

DATA MYDATA1;
input @1 COL1 5.2	@7 COL2 4.1; 
and_=(COL1 > 10 & COL2 > 5 );
or_ = (COL1 > 12 | COL2 > 15 );
not_ = ~( COL2 > 7 );
datalines;
11.21 5.3
3.11  11.4
;
PROC PRINT DATA=MYDATA1;
RUN;

After running the above code, we can get the output below.

Comparison operator

The following table describes the details of the comparison operator. T hese operators compare the values of variables, resulting in true values, 1 for TRUE, and 0 for False. Let's assume that the two data variables V1 and V2 have values of 8 and 4, respectively.

Cases

DATA MYDATA1;
input @1 COL1 5.2	@7 COL2 4.1; 
EQ_ = (COL1 = 11.21);
NEQ_= (COL1 ^= 11.21);
GT_ = (COL2 => 8);
LT_ = (COL2 <= 12);
IN_ = COL2 in( 6.2,5.3,12 );
datalines;
11.21 5.3
3.11  11.4
;
PROC PRINT DATA=MYDATA1;
RUN;

After running the above code, we can get the output below.

Min/Max operator

The following table describes the details of the minimum/maximum operator. These operators compare the values of variables in a row and return the minimum or maximum values in the list of values in the row.

Cases

DATA MYDATA1;
input @1 COL1 5.2	@7 COL2 4.1 @12 COL3 6.3; 
min_ = MIN(COL1 , COL2 , COL3);
max_ = MAX( COL1, COl2 , COL3);
datalines;
11.21 5.3 29.012
3.11  11.4 18.512
;
PROC PRINT DATA=MYDATA1;
RUN;

After running the above code, we can get the output below.

The connection operator

The following table describes the details of the Concatenation operator. T his operator connects two or more string values. Returns a single character value.

Cases

DATA MYDATA1;
input  COL1 $	COL2 $  COL3 $; 
concat_ = (COL1 || COL2 || COL3);
datalines;
Tutorial s point
simple easy learning
;
PROC PRINT DATA=MYDATA1;
RUN;

After running the above code, we can get the output below.

Operator priority

Operator precedence represents the order in which multiple operators exist in complex expressions. The following table describes the order of precedence in a set of operators.