read a excel file into SAS with a specific format

[France]

Dear All,

Could you please give me some suggestion to record the following excel A as table B in the SAS,

Excel A

Name	MOOG 'A'	BOEING	UNITED TECHNOLOGIES
Code	U:MOG.A(P)	U:BA(P)	U:UTX(P)
CURRENCY	U$	U$	U$
28/05/1980	2.0494	4.9817	2.6562
29/05/1980	2.0494	4.8891	2.625
30/05/1980	2	5.0929	2.6719
02/06/1980	2	5.1484	2.7344
03/06/1980	1.9753	5.1484	2.7344
04/06/1980	1.9753	5.278	2.7969
05/06/1980	1.9753	5.1669	2.7812
06/06/1980	1.9753	5.0558	2.7656
09/06/1980	1.9753	5.0743	2.7109
10/06/1980	1.9753	5.1855	2.6797
11/06/1980	1.9753	5.4632	2.7344
12/06/1980	2	5.3706	2.6797
13/06/1980	2	5.4632	2.7031
16/06/1980	2	5.4447	2.7266
17/06/1980	2.0247	5.3706	2.7109

Table B

Name	Code	CURRENCY	DATE	Price
MOOG 'A'	U:MOG.A(P)	U$	28/05/1980	2.0494
MOOG 'A'	U:MOG.A(P)	U$	29/05/1980	2.0494
MOOG 'A'	U:MOG.A(P)	U$	30/05/1980	2
MOOG 'A'	U:MOG.A(P)	U$	02/06/1980	2
MOOG 'A'	U:MOG.A(P)	U$	03/06/1980	1.9753
MOOG 'A'	U:MOG.A(P)	U$	04/06/1980	1.9753
MOOG 'A'	U:MOG.A(P)	U$	05/06/1980	1.9753
MOOG 'A'	U:MOG.A(P)	U$	06/06/1980	1.9753
MOOG 'A'	U:MOG.A(P)	U$	09/06/1980	1.9753
MOOG 'A'	U:MOG.A(P)	U$	10/06/1980	1.9753
MOOG 'A'	U:MOG.A(P)	U$	11/06/1980	1.9753
MOOG 'A'	U:MOG.A(P)	U$	12/06/1980	2
MOOG 'A'	U:MOG.A(P)	U$	13/06/1980	2
MOOG 'A'	U:MOG.A(P)	U$	16/06/1980	2
MOOG 'A'	U:MOG.A(P)	U$	17/06/1980	2.0247
BOEING	U:BA(P)	U$	28/05/1980	4.9817
BOEING	U:BA(P)	U$	29/05/1980	4.8891
BOEING	U:BA(P)	U$	30/05/1980	5.0929
BOEING	U:BA(P)	U$	02/06/1980	5.1484
BOEING	U:BA(P)	U$	03/06/1980	5.1484
BOEING	U:BA(P)	U$	04/06/1980	5.278
BOEING	U:BA(P)	U$	05/06/1980	5.1669
BOEING	U:BA(P)	U$	06/06/1980	5.0558
BOEING	U:BA(P)	U$	09/06/1980	5.0743
BOEING	U:BA(P)	U$	10/06/1980	5.1855
BOEING	U:BA(P)	U$	11/06/1980	5.4632
BOEING	U:BA(P)	U$	12/06/1980	5.3706
BOEING	U:BA(P)	U$	13/06/1980	5.4632
BOEING	U:BA(P)	U$	16/06/1980	5.4447
BOEING	U:BA(P)	U$	17/06/1980	5.3706
UNITED TECHNOLOGIES	U:UTX(P)	U$	28/05/1980	2.6562
UNITED TECHNOLOGIES	U:UTX(P)	U$	29/05/1980	2.625
UNITED TECHNOLOGIES	U:UTX(P)	U$	30/05/1980	2.6719
UNITED TECHNOLOGIES	U:UTX(P)	U$	02/06/1980	2.7344
UNITED TECHNOLOGIES	U:UTX(P)	U$	03/06/1980	2.7344
UNITED TECHNOLOGIES	U:UTX(P)	U$	04/06/1980	2.7969
UNITED TECHNOLOGIES	U:UTX(P)	U$	05/06/1980	2.7812
UNITED TECHNOLOGIES	U:UTX(P)	U$	06/06/1980	2.7656
UNITED TECHNOLOGIES	U:UTX(P)	U$	09/06/1980	2.7109
UNITED TECHNOLOGIES	U:UTX(P)	U$	10/06/1980	2.6797
UNITED TECHNOLOGIES	U:UTX(P)	U$	11/06/1980	2.7344
UNITED TECHNOLOGIES	U:UTX(P)	U$	12/06/1980	2.6797
UNITED TECHNOLOGIES	U:UTX(P)	U$	13/06/1980	2.7031
UNITED TECHNOLOGIES	U:UTX(P)	U$	16/06/1980	2.7266
UNITED TECHNOLOGIES	U:UTX(P)	U$	17/06/1980	2.7109

The excel A is added in the attachment.

thanks in advance.

best regards,

lipeng 

[Reeza]

Read the first data set twice, once to get everything from row 2 down and the second time to get the first two rows only. Transpose both using PROC TRANSPOSE and then merge the results.