SAS/CONNECT User's Guide

Example 2. RLS: Accessing Remote Data by Using the WHERE Statement

Purpose

In this example, WHERE statement processing modifies the previous example in order to reduce the amount of data that is being requested and the impact on network traffic. The WHERE statement moves to local processing only those observations for which a report is being requested. This move is more efficient than moving every observation to local processing and checking the COPY variable for a Y value.

Program

   signon rempc;

[1]
   libname reports 'd:\prod\reports' 
      server=rempc;

[2]
   data _null_;
      set reports.request;
      where copy = "Y";
      put "Report " report_name 
         " has been requested";
   end;

[1] Define a remote library to a local session.

[2] Use the WHERE statement to filter unneeded observations.

Chapter Contents
Previous
Next
Top of Page

	Define a remote library to a local session.
	Use the WHERE statement to filter unneeded observations.