如何生成多个dummy variable

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

求教：
id  type
1   a
2   b
3   a
4   c
5   c
.   .
.   .
.   .
如何对每个id生成三个dummy, 并且dummy名称为type变量值

id  type  a  b  c
1   a      1   0  0  
2   b      0   1  0
3   a      1   0  0
4   c      0   0  1
5   c      0   0  1

扫码加我 拉你入群

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

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

分享0 收藏1 回帖

关键词：Variable Dummy ABLE ABL IAB 如何

data a;
input id type $;
datalines;
1   a
2   b
3   a
4   c
5   c
;
run;
data b;
set a;
x=1;
run;

proc transpose data=b out=c(drop=_name_);
by id type;
id type;
var x;
run;

data d;
set c;
array var{*} _numeric_;
do i=2 to dim(var);
  if var{i}=. then var{i}=0;
end;
drop i;
run;

Too complicated approach.

data a;
input id  type $;
dmy1=(type='a');
dmy2=(type='b');
dmy3=(type='c');
cards;
1   a
2   b
3   a
4   c
5   c
;
run;

proc print;run;

The glmmod can create the dummies automatically. The col1 is (type='a') ... etc.

data a;
input id  type $;
cards;
1   a
2   b
3   a
4   c
5   c
;
run;

proc glmmod data=a OUTDESIGN=b;
class type;
model id=type/noint;
run;

proc print data=b;
run;

bobguy 发表于 2011-8-23 07:07
The glmmod can create the dummies automatically. The col1 is (type='a') ... etc.

data a;

您太牛了！万分感谢

proc sql;
create table b as
select id,
       unique.type as _name_,
           a.type=unique.type as dummy
from a,(select distinct type as type from a) as unique
order by id ,_name_;
quit;
proc transpose data=b out=dummies(drop= _name_);
by id ;
var dummy;
run;

另外,http://www.datavis.ca/sasmac/dummy.html
该地址是利用宏对分类变量创建哑变量,很精彩

yugao1986 发表于 2011-8-23 09:55
proc sql;
create table b as
select id,

大好人啊

yugao1986 发表于 2011-8-23 09:55
proc sql;
create table b as
select id,