Performing Queries Using SQL

Specifying Subsetting Criteria

Now specify that only rows where the value of ActLevel is LOW be displayed. (Do not end the clause with a semicolon.)

proc sql; select actlevel,sex,age, height*2.54 as CentHgt, weight/2.2 as KgWgt from clinic.admit

Copyright © 2002 SAS Institute Inc., Cary, NC, USA. All rights reserved.