Saturday, 8 October 2011

OrderBy Clause SQL


/*to select part of the data*/
proc sql;
select name,age,sex from Customer.class;
quit;
/*assign labels*/
proc sql;
select name 'subjectname', age'subjectage',sex'subjectgender'from Customer.class;
quit;
/*order by clause*/
proc sql;
select*from Customer.class
order by age;
quit;
/*variable position*/

proc sql;
select*from Customer.class
order by 3;
quit;
proc sql;
select*from Customer.class
order by age ,sex desc;
quit;

No comments:

Post a Comment