topic Longitudinal Data in SAS Enterprise Guide in SAS Enterprise Guide

Longitudinal Data in SAS Enterprise Guide

FS — Thu, 28 Apr 2011 20:32:25 GMT

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

Re: Longitudinal Data in SAS Enterprise Guide

Doc_Duke — Fri, 29 Apr 2011 02:16:26 GMT

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.

Re: Longitudinal Data in SAS Enterprise Guide

ChrisHemedinger — Fri, 29 Apr 2011 12:04:02 GMT

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

Re: Longitudinal Data in SAS Enterprise Guide

JohnH — Mon, 02 May 2011 18:25:24 GMT

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