proc import datafile='C:\Documents and Settings\mobileclub\Desktop\source\xls\data1.xls'
out=medi dbms=excel replace;
sheet='demo1$';
run;
proc sql;
select * from Medi
where sex='M';
quit;
proc sql;
select * from medi
where age>=15;
quit;
proc sql;
select * from medi
where age>12 and age<=15;
quit;
proc sql;
select* from medi
where name like 'J%';
quit;
proc sql;
select * from medi
where name like 'j%' or name like 'A%';
quit;
proc sql;
select * from medi
where sex='M' order by age desc;
quit;
No comments:
Post a Comment