How to stack multiple Columns below each other Using SAS SQL (Interleave or Concatenate)???

[Agent1592]

Have table:

Name	ASTRAZENECA PLC	BARCLAYS PLC	BNP PARIBAS
10/22/2003	0.318770648	0.365655639	0.374383913
10/23/2003	0.319576766	0.365696105	0.373288326
10/24/2003	0.315151655	0.36529699	0.370542635
10/27/2003	0.315135441	0.365901666	0.37086854
10/28/2003	0.314288405	0.365839302	0.371058966
10/29/2003	0.314282227	0.3640955	0.371062983
10/30/2003	0.314280745	0.363681904	0.367175412
10/31/2003	0.31502193	0.363453814	0.366553058

Want table:

Date	Name	STD
10/22/2003	ASTRAZENECA PLC	0.318771
10/23/2003	ASTRAZENECA PLC	0.319577
10/24/2003	ASTRAZENECA PLC	0.315152
10/27/2003	ASTRAZENECA PLC	0.315135
10/28/2003	ASTRAZENECA PLC	0.314288
10/29/2003	ASTRAZENECA PLC	0.314282
10/30/2003	ASTRAZENECA PLC	0.314281
10/31/2003	ASTRAZENECA PLC	0.315022
10/22/2003	BARCLAYS PLC	0.365656
10/23/2003	BARCLAYS PLC	0.365696
10/24/2003	BARCLAYS PLC	0.365297
10/27/2003	BARCLAYS PLC	0.365902
10/28/2003	BARCLAYS PLC	0.365839
10/29/2003	BARCLAYS PLC	0.364095
10/30/2003	BARCLAYS PLC	0.363682
10/31/2003	BARCLAYS PLC	0.363454
10/22/2003	BNP PARIBAS	0.374384
10/23/2003	ASTRAZENECA PLC	0.373288
10/24/2003	ASTRAZENECA PLC	0.370543
10/27/2003	ASTRAZENECA PLC	0.370869
10/28/2003	ASTRAZENECA PLC	0.371059
10/29/2003	ASTRAZENECA PLC	0.371063
10/30/2003	ASTRAZENECA PLC	0.367175
10/31/2003	ASTRAZENECA PLC	0.366553

[PeterClemmensen · Accepted solution]

Like this?

data have;
input Name:mmddyy10. ASTRAZENECA_PLC BARCLAYS_PLC BNP_PARIBAS;
format Name mmddyy10.;
datalines;
10/22/2003 0.318770648 0.365655639 0.374383913 
10/23/2003 0.319576766 0.365696105 0.373288326 
10/24/2003 0.315151655 0.36529699 0.370542635 
10/27/2003 0.315135441 0.365901666 0.37086854 
10/28/2003 0.314288405 0.365839302 0.371058966 
10/29/2003 0.314282227 0.3640955 0.371062983 
10/30/2003 0.314280745 0.363681904 0.367175412 
10/31/2003 0.31502193 0.363453814 0.366553058 
;

proc transpose data=have out=want(rename=(name=Date _NAME_=Name COL1=STD));
   by Name;
run;

[Kurt_Bremser]

Look at my answer to your other thread, there you see how it is solved with proc transpose.

[PeterClemmensen]

Btw, is it a requirement to use SQL? Why not PROC TRANSPOSE?

[Kurt_Bremser]

SQL is a database language, and databases are not built in this way (data in structure). You could beat SQL into doing it with macro-preprocessing, but that would be stupid, considering that you just need 4 lines of proc transpose to achieve it.