@rogerward wrote: PROC SQL is appealing since many times it executes faster. In this case, I used 50000 IDs (instead of your 3 records), and 40 questions (instead of your 4 questions), and ran the one SQL solution from @Tom   NOTE: PROCEDURE SQL used (Total process time): real time 2.28 seconds user cpu time 2.62 seconds system cpu time 0.64 seconds   NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 1.62 seconds user cpu time 1.62 seconds system cpu time 0.00 seconds ... View more