楼主: yz830215
4391 13

求助高手:统计频数 proc mens; [推广有奖]

11
yz830215 发表于 2009-6-8 09:19:00
谢谢你的参与,思想我也可以学习下.

12
yz830215 发表于 2009-6-8 09:19:00
虽然没能生成数据集,也是很感谢了,我也学习研究下.

13
jingju11 发表于 2009-6-8 21:40:00

data ss;

ss;

input x y z @@;

x y z @@;

cards;

1 2 3 4 5 1 7 2 1 5 6 1 6 4 2 . 1 1

;

;

1 2 3 4 5 1 7 2 1 5 6 1 6 4 2 . 1 1

;

run;

;

proc contents out=d(where=(type=1)) noprint;run;

contents out=d(where=(type=1)) noprint;run;

proc sql noprint;

select name

,cats('_N1_',name)

into :name separated by ' '

sql noprint;

select name

,cats('_N1_',name)

into :name separated by ' '

select name

,cats('_N1_',name)

into :name separated by ' '

'_N1_',name)

into :name separated by ' '

into :name separated by ' '

,:name1 separated by ' ' from d

;

by ' ' from d

;

quit;

;

data ss1(keep=_n1_:);

set ss end=endof;

retain &name;

array Ary{*} &name;

array _Ary{*} &name1.;

do i=1 to dim(Ary);

_ary{i}+(ary{i}=1 | missing(ary{i}));

end;

if endof;

ss1(keep=_n1_:);

set ss end=endof;

retain &name;

array Ary{*} &name;

array _Ary{*} &name1.;

do i=1 to dim(Ary);

_ary{i}+(ary{i}=1 | missing(ary{i}));

end;

if endof;

set ss end=endof;

retain &name;

array Ary{*} &name;

array _Ary{*} &name1.;

do i=1 to dim(Ary);

_ary{i}+(ary{i}=1 | missing(ary{i}));

end;

if endof;

retain &name;

array Ary{*} &name;

array _Ary{*} &name1.;

do i=1 to dim(Ary);

_ary{i}+(ary{i}=1 | missing(ary{i}));

end;

if endof;

array Ary{*} &name;

array _Ary{*} &name1.;

do i=1 to dim(Ary);

_ary{i}+(ary{i}=1 | missing(ary{i}));

end;

if endof;

array _Ary{*} &name1.;

do i=1 to dim(Ary);

_ary{i}+(ary{i}=1 | missing(ary{i}));

end;

if endof;

do i=1 to dim(Ary);

_ary{i}+(ary{i}=1 | missing(ary{i}));

end;

if endof;

1 | missing(ary{i}));

end;

if endof;

end;

if endof;

if endof;

run;

;

14
jingju11 发表于 2009-6-8 21:41:00
sorry why so many replicates?

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注cda
拉您进交流群
GMT+8, 2025-12-29 15:40