-
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 or equal to 90.data readin;
input
name
$
Section
$ Score;
cards;
Raj A 80
Atul A 77
Priya B 45
Sandeep A 95
Rahul C 84
Shreya C 44
;
run;
data readin1;
set
readin;
where
Score
between
50
and
90;
run;
where Score between 50 and 90 => This would tell SAS to select values through 50 and 90 (not 51 to 89).
This can also be written like:
where Score GE 50 and Score LE 90;
-
CONTAINS Operator: Searching specific character
Task 2: Suppose you want to select only those observations in which students’ name contain ‘hil’.
data readin;
input
name
$
Section
$ Score;
cards;
Raj A 80
Atul A 77
Priya B 45
Sandeep A 95
Rahil C 84
Sahil B 44
;
run;
data readin1;
set
readin;
where
name
contains
'hil'
;
run;
where name contains ‘hil’ => This would tell SAS to select observations having the values Rahil, Sahil for the variable NAME.
Note: The CONTAINS operator is case sensitive.
Article Tags :