sas
data步 读数据集后常用的操作
keep#保留列
drop#丢弃列
label#修改label# label var = ‘ajd’
rename#修改name
where#配套<>=,etc
if then
delete
output
do#e.g.
data df;#创建数据
input class:$10.no;
cards;
a 10
b 17
;
run;
data df1;
set(df)
do kk=1 to no;
id=compress('id is' ||put(kk,z3.))
output;
end;
run;
input()#函数,字符串转换为数值
put()#函数,数值转换为字符串
compress(‘abc’,‘ab’) = c#删除字符串中的特定字符.
链接语句merge
e.g.
#创建俩数据集实验
data n;
input class:$10.num;
cards;
a 10
d 23
b 34
;
run;
data m;
input class:$10.score;
cards;
a 88;
b 22;
c 32;
;
run;
#连接前要先排序,用sort proc
proc sort data=n;
by class;
run;
proc sort data=m;
by class;
run;
data a b c d;#创建四个变量分别接受左连接/右链接/全连接/内连接
merge n(in=nn) m(in=mm);#in给别名
by class;#连接列
if nn then ouput a;#left join
if mm then ouput b;#right join
if nn and mm then ouput c;#inner join
if nn or mm then ouput d;#outer join
run;