SAS OnlineTutor HomeFAQ PageSuggested Learning PathsContents+Searchback||next

Performing Queries Using SQL
Selecting Columns


Question:


You've decided to create two new columns for your query. In the SELECT clause, create the columns CentHgt and KgWgt, in that order. Define CentHgt as the value of Height multiplied by 2.54. Define KgWgt as the value of Weight divided by 2.2.

(The comma after Age has been supplied for you.)

proc sql;
   select actlevel,sex,age,
      

           

  back||next

 

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

Terms of Use & Legal Information | Privacy Statement