/*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