On Thu, 9 Nov 2006 11:02:09 -0500, Steven Lolay <stevenlolay@IF.COM> wrote:
>Is it possible for you to produce a datset which has 2 records for each
>category ie a Y and No with the code below:
>INPUT match 1. cat $20.;
>1Offset not Active
>proc sort data=dummy_1;by match;;run;
>INPUT match 1. erc $1.;
>proc sort data=dummy_2;by match;run;
>merge dummy_1 dummy_2;
>I think it's called a cartesian join but could be wrong!!!
>Could you please tick the box to send me a reply as in a rush.
It's done most easily with SQL, and unless you really have additional groups
you do not need the MATCH columns.
INPUT cat $20.;
Offset not Active
INPUT erc : $1.;
create table dummy as
select * from dummy_1 cross join dummy_2
order by cat, erc desc;
Offset Active Y
Offset Active N
Offset not Active Y
Offset not Active N