Desktop productivity for business analysts and programmers

Longitudinal Data in SAS Enterprise Guide

Reply
FS
N/A
Posts: 1

Longitudinal Data in SAS Enterprise Guide

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
Valued Guide
Posts: 2,111

Re: Longitudinal Data in SAS Enterprise Guide

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.
Community Manager
Posts: 2,693

Re: Longitudinal Data in SAS Enterprise Guide

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
Contributor
Posts: 73

Re: Longitudinal Data in SAS Enterprise Guide

if you are dealing with event history data, use PROC EXPAND, which is a point & click task in EG.
Ask a Question
Discussion stats
  • 3 replies
  • 515 views
  • 0 likes
  • 4 in conversation