Longitudinal Data in SAS Enterprise Guide

[FS]

Hi,

How can I change longitudinal data from 'long' format to 'wide' format?
I know how to do it in main SAS.

Thank you,

FS

[Doc_Duke]

In EGuide 4.3,

Tasks -- data -- Split columns

Will get you to PROC TRANSPOSE to take many rows into many columns.

Use the Stack columns task to go the other way.

[ChrisHemedinger]

You can also write your own code to do it, as you would do in Base SAS.

File->New->Program...

And then use techniques as Rick describes here:
http://blogs.sas.com/iml/index.php?/archives/83-Reshaping-Data-from-Wide-to-Long-Format.html

[JohnH]

if you are dealing with event history data, use PROC EXPAND, which is a point & click task in EG.