如何比较数据集中某一列任何两行的值是否相等

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

请教:如何比较数据集中某一列任何两行的值是否相等

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：数据集 如何

不明白你说的什么意思啊

拿EXCEL来举例，如比较单元格A(3,1)和A(6,1)值的大小，返回一个逻辑值，在SAS中如何比较?

dataset 自己和自己 Cartesian join。比如说
DATA one;
        INPUT idx id;
        DATALINES;
        1 1
        2 2
        3 2
        ;
RUN;
proc sql;
        create table test as
        select a.idx as a_idx, a.id as a_id, b.idx as b_idx, b.id as b_id,
                        case when a.id = b.id then 'Y' else 'N' end as equal
        from one a, one b where a.idx ne b.idx;
quit;
从结果能够看到row2和row3的id是一样的。

Here is an example. Please take look if it is what you want.

801  data t1;
802     retain x1-x3 0;
803     retain y1-y5 'c';
804     array x(3) ;
805     array y(5) ;
806
807     do i=1 to 5;
808        do j=1 to dim(x);
809           x[j]=ranuni(123);
810        end;
811        do j=1 to dim(y);
812           y[j]=byte( ceil(20*ranuni(123))+64);
813        end;
814        output;
815        if i=3 then output;
816      end;
817  run;

NOTE: The data set WORK.T1 has 6 observations and 10 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


818  proc print;run;

NOTE: There were 6 observations read from the data set WORK.T1.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


819  proc sort data=t1 out=nodup_t1  dupout=d nodup; by _all_; run;

NOTE: There were 6 observations read from the data set WORK.T1.
NOTE: 1 duplicate observations were deleted.
NOTE: The data set WORK.NODUP_T1 has 5 observations and 10 variables.
NOTE: The data set WORK.D has 1 observations and 10 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds

Thank you!