Examples of Data Transfer Services (DTS)

Example 8. DTS: Transferring Numerics by Using the EXTENDSN= and V6TRANSPORT Options

For SAS releases before SAS 8, when you transfer short numerics (length less than 8), the length of these numerics is automatically increased to preserve precision. In SAS 8, the length of these numerics is not increased by default unless the V6TRANSPORT option is specified. Using the V6TRANSPORT and EXTENDSN= options in PROC UPLOAD and PROC DOWNLOAD statements, you can choose whether to promote the length of numerics.

Programs

Example 8.1: Using the EXTENDSN= and V6TRANSPORT Options in the PROC UPLOAD Statement

This example uploads the data set A in the directory WORK on the client to the directory REMOTE on the server. The V6TRANSPORT option causes the short numerics to be promoted. Therefore, EXTENDSN=NO must be specified to override this default, so that numerics will not be promoted.

proc upload data=a out=remote 
   v6transport extendsn=no;
run;

Example 8.2: Using the EXTENDSN= Option in the PROC DOWNLOAD Statement

This example downloads the catalog SCAT in the directory REMOTE on the server to the directory WORK on the client. By default, catalog transfers promote the length of short numerics within SCREEN entry types. This behavior can be overridden by specifying EXTENDSN=NO on the catalog transfer download. The EXTENDSN= option is supported by catalog transfer of SCREEN entry types only.

Note: The V6TRANSPORT option is unnecessary when transferring a catalog. [cautionend]

proc download incat=remote.scat outcat=work.scat 
   extendsn=no;
run;

Top of Page