Agri521最近对Scientific data management 非常感兴趣，这对将来的研究工作有很大的帮助。为此，本人设计了科研数据管理数据库，用于大量实验数据的存储；实现了与SAS Dataset的无缝传输，用于大量数据的统计分析。
下面列出了MS ACCESS与SAS DATA TRANSFER的几种方法。
| 方法 | 附加软件 | 说明 |
| CSV | None | 1. Save each Access table as csv file, then read in by DATA step. 2. Input statement should match the column ordering and data type in database table. |
| DDE | None | 1. Type each Access table name in DDE statement. 2. An input statement be written to match the layout of columns. 3. Invoke MS Access and open the table file to be input. 4. MS Access cannot have a '.' as missing value for numerics. |
| PROC ACCESS | SAS/Access to PC file formats | 1. Need to save Access file as a Microsoft Excel 5.0/95 Workbook file, but doesn't need input statement. 2. Column limit is 256, long value may be truncated with an error message. |
| ODBC | 1. SAS/Access interface to ODBC. 2. Microsoft Access ODBC driver. |
1. Get ODBC installed and configured. 2. Define DSN reference to database(.mdb file) |
| Third party solution | 第三方软件，如 DBMS/COPY, DBMS/Engine. | 1. Buy and get software installed and configured. 2. Define some parameters if necessary. |
| PROC IMPORT | SAS/Access to PC file formats | Type each table name in SAS progrma before data transfer. |
苏ICP备08103697号
已经好了，不错!
Reply
wa~~好高深
Reply