SAS中产生笛卡尔积的几种方法

proc sql;
    create table want as
        select a.*, b.*
        from demo1 a, demo2 b
        where A <= ID <= B
        ;
quit;

data want;
    set demo1;
    do i=1 to n;
        set demo2 point=i nobs=n;
        if A <= ID <= B then output;
    end;
run;

data want;
    if _n_=1 then do;
        if 0 then set demo2;
        dcl hash h(dataset:'demo2');
        dcl hiter hit('h');
        h.definekey('C');
        h.definedata('A', 'B', 'C');
        h.definedone();
    end;
    set demo1;
    do while(hit.next()=0);
        if A <= ID <= B then output;
    end;
run;