Trying to transpose a dataset .

[khandelwalanmol]

I have trying to transform a dataset which is in raw format.

I need the data to be transposed.

The sequence and linenum in both the datasets is same.

Attaching the screenshots of the raw and requires transposed dataset.

[tarheel13]

Can you please post your data as datelines and post your code that you tried? 

[Reeza]

It looks like you're using EG. Have you tried the Transpose GUI task or are you looking for code?

proc transpose data=have out=want prefix = _procmod;
by eobkey;
id sequence;
var procmod;
run;

If this doesn't work for some reason, please explain how and provide details.

[ballardw]

Your output implies that the Procmod value of ER is on a record with Sequence=10. But that is not the case in the data. Linenum is missing for that record. So, how are we supposed to know that Linenum=10 should be used in this case? Or any of the cases where Sequence is actually missing?

Hint: sequence numbers that are not actually numeric can be a bit difficult to work with at times.

[khandelwalanmol]

yes, the procmod belongs to the next sequence number in the sequence row.
for eg, LT belongs to sequence 6, Sequence 10 has two iterations ER and 25.
The sequence comes in the next row for every procmod.