SAS OnlineTutor HomeFAQ PageSuggested Learning PathsContents+Searchback||next

Performing Queries Using SQL
Ordering Rows


Question: Add a clause specifying that rows be ordered by values of the column Age. (Don't 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
           where actlevel='LOW'
           

           

  back||next

 

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

Terms of Use & Legal Information | Privacy Statement