topic Transpose a table in SAS Programming

Transpose a table

WilliamB — Thu, 23 Jan 2020 15:10:45 GMT

Hello,
I would like to transpose a table.
I only want one the same value in ID.

Thanks a lot for your help.

TABLE

ID	CODE	DATE
01	FAZ58	07/01/2020
01	FZE78	04/01/2020
02	DS52	05/01/2020
02	YU89	04/01/2020
02	LM69	04/01/2020
03	DS24	05/01/2020
04	FS24	06/01/2020
04	XC89	07/01/2020

WANT:

ID	CODE1	DATE1	CODE2	DATE2	CODE3	DATE3
01	FAZ58	07/01/2020	FZE78	04/01/2020
02	DS52	05/01/2020	YU89	04/01/2020	LM69	04/01/2020
03	DS24	05/01/2020
04	FS24	06/01/2020	XC89	07/01/2020

Re: Transpose a table

PeterClemmensen — Thu, 23 Jan 2020 15:14:05 GMT

Why do you want to do this? 🙂

Re: Transpose a table

novinosrin — Thu, 23 Jan 2020 15:17:48 GMT

data have;	 
input ID $	CODE $	DATE	:ddmmyy10.;
format date ddmmyy10.;
cards; 
01	FAZ58	07/01/2020	 	 	 	 
01	FZE78	04/01/2020	 	 	 	 
02	DS52	05/01/2020	 	 	 	 
02	YU89	04/01/2020	 	 	 	 
02	LM69	04/01/2020	 	 	 	 
03	DS24	05/01/2020	 	 	 	 
04	FS24	06/01/2020	 	 	 	 
04	XC89	07/01/2020	 	 	
;

proc sql noprint; 
 select max(obs) into :obs 
from  ( select count(*) as obs from have group by id ) ;
quit;

proc summary nway data=have missing; 
 class id ; 
 output out = want(drop=_type_ _freq_)
 idgroup(out[&obs](code date)=);
run;

Re: Transpose a table

WilliamB — Thu, 23 Jan 2020 15:26:05 GMT

thank you so much