Help with Transposing the data

pp2014 — Tue, 28 Jul 2015 16:21:08 GMT

I have the following data:

data have;

input id $1. prd_id $2. prd $3. seq rx;

cards;

1 12 xyz 1 8

1 12 xyz 2 5

1 12 xyz 3 7

1 12 xyz 4 8

1 13 abc 2 5

1 13 abc 3 4

1 13 abc 5 9

I want the output as follows:

id prd_id prd rx1 rx2 rx3 rx4 rx5

1 12 xyz 8 5 7 8 .

1 13 abc . 5 4 . 9

Re: Help with Transposing the data

Reeza — Tue, 28 Jul 2015 16:39:28 GMT

Straightforward proc transpose, remember to sort first.

proc transpose data=have out=want prefix=rx;

by id prd_id prd;

var rx;

id seq;

run;