Date:         Thu, 21 May 2009 09:31:20 -0400
Reply-To:     Croghan.Carry@EPAMAIL.EPA.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Carry Croghan <Croghan.Carry@EPAMAIL.EPA.GOV>
Subject:      Re: How to transpose data by using arrays
Comments: To: Shaik Hymad <hymadsk@GMAIL.COM>
In-Reply-To:  <200905211015.n4KLJDOg003924@malibu.cc.uga.edu>
Content-type: text/plain; charset=US-ASCII

you don't need to use an array just a retain statement.

data trans(keep = pid v1 v2);
      set orginal;
      by pid;
retain v1 .;;

if first.pid v1=MBR;

else do;
v2=MBR;
output;;
end;
run;


Carry W. Croghan
Database Manager
EPA\ORD\NERL\HEASD
RTP, NC




  From:       Shaik Hymad <hymadsk@GMAIL.COM>

  To:         SAS-L@LISTSERV.UGA.EDU

  Date:       05/21/2009 06:16 AM

  Subject:    How to transpose data by using arrays






HI TO ALL,

i HAV DATASET LIKE

PID VR VN  MBR
001 1  V1   0
001 2  V2   0
002 1  V1   0
002 2  V2   0
002 1  V1   0
002 2  V2   0


 I NEED TO OUTPUT LIKE...
by subject - transpose to present missed brus(MBR) recorded at v1,v2 and
overall for each subject on same observation
USING DATASTEP IN ARRAYS

 IF U KNOW ANY  ONE PLEASE HELP ME

THANKS,
HYMAD