Working with SAS Data Sets |
Using the READ Statement with the WHERE Clause |
Use the WHERE clause as you did with the LIST statement, to conditionally select observations from within the specified range. If you want to create a matrix FEMALE that contains the variables AGE, HEIGHT, and WEIGHT for females only, use the following statements:
> read all var _num_ into female where(sex="F"); > print female; FEMALE 11 51.3 50.5 12 59.8 84.5 12 56.3 77 13 56.5 84 13 65.3 98 14 62.8 102.5 14 64.3 90 15 62.5 112.5 15 66.5 112
Now try some special features of the WHERE clause to find values that begin with certain characters (the =: operator) or that contain certain strings (the ? operator). To create a matrix that contains the students whose names begin with the letter "J," use the following statements:
> read all var{name} into j where(name=:"J"); > print j; J JOYCE JAMES JANE JOHN JEFFREY JUDY JANET
To create a matrix of children with names that contains the string "AL," use the following statement:
> read all var{name} into al where(name?"AL"); > print al; AL ALICE ALFRED RONALD
Copyright © SAS Institute, Inc. All Rights Reserved.