Open In App

Contains and Between-And operators in SAS Programming

Improve
Improve
Like Article
Like
Save
Share
Report
  1. 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).

    Output

    This can also be written like:

    where Score GE 50 and Score LE 90;

  2. 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.

    Output


Last Updated : 23 Jul, 2019
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads