Previous Page | Next Page

Examples of Data Transfer Services (DTS)

Example 1. DTS: Transferring Data by Using WHERE Statements


Purpose

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.


Program

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;

Previous Page | Next Page | Top of Page