Hi Kurt, Thanks for your response. Here's the code of a sample dataset: data have;
input orderid $5. product $20. bundle $2.;
datalines;
1234,1
1234,2
1232,5
;
run;
data want;
input orderid $5. product $20. bundle $2.;
datalines;
1234,1,1
1234,2,1
1232,5,0
;
run;
In the above those lines where product = 1 and product = 2 beside the same order number would have bundle = 1? Does that make sense? Cheers, Jordan
... View more