p********2 发帖数: 9939 | 1 The access data is big, maybe several GB. Everytime I tried to import access
as SAS, it says "out of source". How could I breakdown the data
observations and then import separately? Or is there any other way to save
access data as SAS file?
Many thanks. | d*******o 发帖数: 493 | 2 I used to deal with the similar situation. The reason is that: Microsoft
ODBC/OLEDB engine for EXCEL/ACCESS is outdated and limited to handle large
datasets. However, Microsoft ODBC engine for SQL server is designed for
large scale. You could install Microsoft SQL server and use it as a middle
layer to import ACCESS datasets into SAS. |
|