Moving multiple rows to single row

[timppap]

I have this kind of data

TiliA TiliB
A 1
A 2
A 3
B 1
B 2

I want to get like this

TiliA TiliB
A 1 2 3
B 1 2

How to do it ?
Thanks

 

[MatthiasB]

Quite some time ago, maybe still current - try something like this:

proc sort data=oldTab; by tiliA tiliB; run;
data newTab;
  set oldTab (rename=(tiliB=oneB));
  by tiliA;
  length tiliB $50;  /* or whatever length you need */
  retain tiliB;
  if first.tiliA
    then tiliB = left(oneB);
	else tiliB = trim(tiliB) !! ' ' !! left(oneB);
  if last.tiliA then
   output;
run;

 

[timppap]

Thanks I try !

 

[sasbuddy]

Try PROC Transpose

 

[Amitok]

Proc Sort Data=NEW ;
  By TiliA ;
Run;

Data New ;
  Retain TiliB ;
  Set Old ;
  By TiliA ;
  If First.TiliA Then
  DO;
    TiliB = "" ;
    TiliB = TiliB!!" "!!TiliA ;
  END;
  IF Last.TiliA Then Output ;
RUN;