Peng, For your SQL server approach, the WHERE clause MAY (or MAY NOT) execute on the remote server. It depends on whether the WHERE clause includes any functions or operators that are NOT supported on the SQL Server. SAS will try to create native SQL code and do all the work on the SQL server, but if it is unsuccessful, then it will transfer the data to the PC and process it there. To guarantee that the code is executed on the SQL server, use Pass Thru SQL from SAS. See the SAS/Access documentation for your flavor of SQL for debugging options and functions that may be constrained. Doc Muhlbaier Duke
... View more