Working with SAS Data Sets

Use the READ Statement with the WHERE Clause

Use the WHERE clause to conditionally select observations from within the specified range. The following statements create a matrix to contain the variables Age, Height, and Weight for females in the Sashelp.Class data set: 

use Sashelp.Class;
read all var _num_ into Female where(sex="F");
print Female;

Figure 7.13: Female Students

Female
13 56.5 84
13 65.3 98
14 62.8 102.5
12 59.8 84.5
15 62.5 112.5
11 51.3 50.5
14 64.3 90
12 56.3 77
15 66.5 112 




            

            


            
The section Process Data by Using the WHERE Clause describes other features of the WHERE clause. For example, you can create a matrix to contain the student names that begin
               with the letter "J," by using the following statements: 
            


read all var {Name} into J where(name=:"J");
print J;



  

            


Figure 7.14: Names That Begin with the Letter J

               

                  

                     
                     

                        
                        
                        

                           
                           

                              
                              




J
                                       
                                    




James
                                       
                                    



Jane
                                       
                                    



Janet
                                       
                                    



Jeffrey
                                       
                                    



John
                                       
                                    



Joyce
                                       
                                    



Judy