Example 1. DTS: Transferring Data by Using WHERE Statements

The UPLOAD and DOWNLOAD procedures process WHERE statements and the WHERE= data set option when you transfer a single SAS data set. Because the transferred data set contains only the observations that meet the WHERE condition, transfer time is minimized.

signon foo sascmd="!sascmd -nosyntaxcheck";

data school;
length name $ 20 class $1;
input name class amount;
cards;
Tom K 30
Sue 1 10
Ab K 3
;

rsubmit status=no;
proc upload data=school out=kindergarten;
   where class='K';
run;