topic Re: Trying to transpose a dataset . in SAS Programming

Trying to transpose a dataset .

khandelwalanmol — Tue, 15 Jun 2021 13:55:03 GMT

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.

Re: Trying to transpose a dataset .

tarheel13 — Tue, 15 Jun 2021 14:48:26 GMT

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

Re: Trying to transpose a dataset .

Reeza — Tue, 15 Jun 2021 14:51:47 GMT

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.

Re: Trying to transpose a dataset .

ballardw — Tue, 15 Jun 2021 14:52:03 GMT

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.

Re: Trying to transpose a dataset .

khandelwalanmol — Tue, 15 Jun 2021 15:11:47 GMT

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.