SAS SQL
- 语法
- SQL CREATE
- SQL SELECT
- SQL SELECT with WHERE Clause
- SQL UPDATE
- SQL DELETE
语法
proc sql;
select columns
from table
where columns
group by columns
;
quit;
SQL查询在proc sql语句之后,加上quit语句,用于结束SQL查询
SQL CREATE
data example;
input id $ name $ studynum;
datalines;
1 Maria 2024168001
2 Michelle 2024168002
3 Lucy 2024168003
4 Gary 2024168004
;
run;
proc sql;
create table temp as
select * from example
;
quit;
SQL SELECT
proc sql;
select name,height,weight
from sashelp.class
;
quit;
SQL SELECT with WHERE Clause
proc sql;
select name,height,weight
from sashelp.class
where height > 60
;
quit;
SQL UPDATE
proc sql;
create table class as
select name as student,
sex as gender,
age as year,
height as stuheight,
weight as stuweight,
weight/((height/100)*(height/100)) as bmi
from sashelp.class;
quit;
proc sql;
update class
set stuheight=stuheight/100;
quit;
SQL DELETE
proc sql;
delete from class
where weight<60;
quit;