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
