全部版块 我的主页
› 论坛 › 数据科学与人工智能 › 数据分析与数据科学 › SAS专版
如何插入需要补全的值？
fyp198744
2415 14
2016-08-26
kindvalueAEBODSYSAEDECOD

1

104

4

218

1

2

Blood and lymphatic system disorders

4

5

Blood and lymphatic system disorders

4

4

Blood and lymphatic system disordersAnaemia

1

1

Blood and lymphatic system disordersHypochromic anaemia

1

1

Blood and lymphatic system disordersLeukocytosis

4

1

Blood and lymphatic system disordersMonocytosis

1

4

Cardiac disorders

4

6

Cardiac disorders

4

1

Cardiac disordersAcute myocardial infarction

4

1

Cardiac disordersAngina unstable

4

1

Cardiac disordersAtrial fibrillation

4

1

Cardiac disordersAtrioventricular block

4

1

Cardiac disordersCardiac failure

1

2

Cardiac disordersCoronary artery disease

1

1

Cardiac disordersCoronary artery insufficiency

4

2

Congenital, familial and genetic disorders

1

1

Congenital, familial and genetic disordersType IV hyperlipidaemia

4

1

Congenital, familial and genetic disordersType V hyperlipidaemia
我希望补全成
kindvalueAEBODSYSAEDECOD

1

104

4

218

1

2

Blood and lymphatic system disorders

4

5

Blood and lymphatic system disorders

1

0

Blood and lymphatic system disordersAnaemia

4

4

Blood and lymphatic system disordersAnaemia

1

1

Blood and lymphatic system disordersHypochromic anaemia

4

0

Blood and lymphatic system disordersHypochromic anaemia

1

1

Blood and lymphatic system disordersLeukocytosis

4

1

Blood and lymphatic system disordersMonocytosis

1

4

Cardiac disorders

4

6

Cardiac disorders

1

0

Cardiac disordersAcute myocardial infarction

4

1

Cardiac disordersAcute myocardial infarction

1

0

Cardiac disordersAngina unstable

4

1

Cardiac disordersAngina unstable

1

0

Cardiac disordersAtrial fibrillation

4

1

Cardiac disordersAtrial fibrillation

1

0

Cardiac disordersAtrioventricular block

4

1

Cardiac disordersAtrioventricular block

1

0

Cardiac disordersCardiac failure

4

1

Cardiac disordersCardiac failure

1

2

Cardiac disordersCoronary artery disease

4

0

Cardiac disordersCoronary artery disease

1

1

Cardiac disordersCoronary artery insufficiency

4

0

Cardiac disordersCoronary artery insufficiency

1

0

Congenital, familial and genetic disorders

4

2

Congenital, familial and genetic disorders

1

0

Congenital, familial and genetic disordersType IV hyperlipidaemia

4

1

Congenital, familial and genetic disordersType IV hyperlipidaemia

1

0

Congenital, familial and genetic disordersType V hyperlipidaemia

4

1

Congenital, familial and genetic disordersType V hyperlipidaemia

就是每个AEDECOD或者AEBODSYS都有1,4两种kind；

有什么办法吗？
二维码

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

全部回复
独木者
2016-8-26 16:12:18
提供一种可能的思路，不知道对不？
1.对原始数据集raw数据集sort by kind aebodsys aedecod nodupkey out=a;
2.建一个temp数据集（aebodsys aedecod为nodupkey的值）：do kind=1,4;do aebodsys=  ;aedecod= ;
3.merge raw temp;by kind aebodsys aedecod;
4.将value为空的值的row去掉
二维码

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

wwang111
2016-8-26 16:25:32
AEBODSYS='Blood and lymphatic system disorders', AEDECOD='Leukocytosis' 或 'Monocytosis'的时候，需不需要补？

就是补一条Leukocytosis的kind=4 和 Monocytosis的kind=1的？
二维码

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

fyp198744
2016-8-26 16:36:10
wwang111 发表于 2016-8-26 16:25
AEBODSYS='Blood and lymphatic system disorders', AEDECOD='Leukocytosis' 或 'Monocytosis'的时候，需不 ...
要补的，这个是我疏忽了，简单来说，凡是出现过的记录，都得有1、4两条记录！
二维码

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

wwang111
2016-8-26 16:40:41
试试这个：

proc sql;
create table needcomp as
select distinct aebodsys, aedecod, kind
from test
group by 1,2
having count(*)=1;
quit;

data comp;
set needcomp;
if kind=4 then kind=1;
else if kind=1 then kind=4;
value=0;
run;

data newdata;
set test comp;
run;

proc sort data=newdata;
by aebodsys aedecod kind;
run;
二维码

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

fyp198744
2016-8-28 07:03:16
wwang111 发表于 2016-8-26 16:40
试试这个：

proc sql;
我突然想到一种很另类的方法：
proc trance data=origin out=mid:
    by AEBODSYS   AEDECOD;
    var  value;
    id kind;
run;
data need;
    set mid(drop=_4 rename=(_1=vall));
    kind=1;
    set mid(drop=_1 rename=(_4=val));
    kind=4;
run;
是不是很巧妙？
二维码

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

点击查看更多内容…
相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

微信QQ空间QQ微博
扫码加好友，拉您进群
各岗位、行业、专业交流群