topic How to transpose data like this? in SAS Procedures

How to transpose data like this?

MikeTurner — Tue, 17 Jan 2012 06:35:21 GMT

I want to transpose the following data:

a b 1 x1 y1 x2 y2

c d 2 x3 y3 x4 y4;

Into:

a b 1 x1 y1

a b 1 x2 y2

c d 2 x3 y3

c d 2 x4 y4;

How to program?

Thanks!

How to transpose data like this?

Ksharp — Tue, 17 Jan 2012 06:51:35 GMT

These data are in TXT file ?

data want;
infile datalines dlm=' ' truncover;
input a $ b $ c $ d $ e $ @;
do until( missing(d)); 
 output;
 input d $ e $ @; 
end;
input;
datalines;
a b 1 x1 y1 x2 y2
c d 2 x3 y3 x4 y4
;
run;

Ksharp

How to transpose data like this?

MikeTurner — Tue, 17 Jan 2012 08:13:58 GMT

Thanks. But if the original data are in one datset, how to program it/

How to transpose data like this?

Ksharp — Tue, 17 Jan 2012 08:24:42 GMT

You have Five variables or Only one variable to hold a record?

How to transpose data like this?

MikeTurner — Tue, 17 Jan 2012 09:17:12 GMT

Thanks.

I have seven variables in my original dataset. Now I want to hold a record (5 variables) using the first 3 variables.

How to transpose data like this?

Ksharp — Tue, 17 Jan 2012 09:52:00 GMT

OK.

data have;
input (a1 - a7) (: $40.);
datalines;
a b 1 x1 y1 x2 y2
c d 2 x3 y3 x4 y4
;
run;
data want(drop=a4-a7);
 set have;
 x=a4;y=a5;output;
 x=a6;y=a7;output;
run;

Ksharp

How to transpose data like this?

Ksharp — Tue, 17 Jan 2012 09:53:01 GMT

If you have only one variable.




data have;
infile datalines length=len;
input a $varying200. len;
datalines;
a b 1 x1 y1 x2 y2
c d 2 x3 y3 x4 y4
;
run;
data want(keep=xx);
 set have;
 length x xx $ 400;
 i=4;
 x=catx(' ',scan(a,1),scan(a,2),scan(a,3));
 xx=catx(' ',x,scan(a,i),scan(a,i+1));
 do until(missing(scan(a,i)));
 output;
 i+2;
 xx=catx(' ',x,scan(a,i),scan(a,i+1));
 end;
run;

Ksharp