Hi again, 1st of all, below is the SAS code for the data: data have;
input zip $ item $ box1 box2 box3 percent;
format percent percent. ;
datalines;
00501 22 1 1 0 0.1
00501 42 2 0 0 0.3
00501 99 1 1 6 0.6
00101 22 2 10 30 0.28
00101 23 48 24 60 0.45
00101 31 40 20 50 1
00101 42 56 36 70 0.42
;
run;
proc print;
run; Which will give you this: I'd like to ask for the simplest solution to be able to go from that table, to a semi-transposed (or technically, a pivoted) dataset. The item codes will be constant. Below are all the possible item codes if it matters: 22
23
31
42
52
62
72
82
99 Any help pointing me to the right direction will be very much appreciated. Regards, Tony
... View more