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;
Tom K 30
Sue 1 10
Ab K 3

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