Options for Other Functions

BYSORT=YES | NO

LIBNAME mydatalib sasspds 'conversion_area'
   server=husky.5105
   user='siteusr1'
   prompt=yes
   bysort=no ;

data mydatalib.old_autos;
   input
     year $4.
     @6 manufacturer $12.
     model $10.
     body_style $5.
     engine_liters
     @39 transmission_type $1.
     @41 exterior_color $10.
     options $10.
     mileage condition ;
   datalines ;

1971 Buick       Skylark   conv  5.8  A  yellow    00000001 143000 2
1982 Ford        Fiesta    hatch 1.2  M  silver    00000001  70000 3
1975 Lancia      Beta      2door 1.8  M  dk blue   00000010  80000 4
1966 Oldsmobile  Toronado  2door 7.0  A  black     11000010 110000 3
1969 Ford        Mustang   sptrf 7.1  M  red       00000111 125000 3
;

PROC PRINT data=mydatalib.old_autos;
   by model;
run;

PROC PRINT data=mydatalib.old_autos
 (bysort=yes);
  by model;
run; 

DISCONNECT=YES | NO 

LIBNAME spud sasspds 'potatoes' 
   server=husky.6100 
   user='bob' 
   passwd='bob123';

NOTE: Libref SPUD was successfully assigned as follows: 
      Engine:        SASSPDS 
      Physical Name: :8292/spds/test/potatoes/

LIBNAME spud clear;

LIBNAME cake sasspds 'carrots' 
   server=husky.6100 
   user='bob' 
   passwd='bob123';

NOTE: Libref CAKE was successfully assigned as follows: 
      Engine:        SASSPDS 
      Physical Name: :8292/spds/test/carrots/

LIBNAME spud sasspds 'potatoes' 
   server=husky.6100 
   user='bob' 
   passwd='bob123'
DISCONNECT=YES;

NOTE: Libref SPUD was successfully assigned as follows: 
      Engine:        SASSPDS 
      Physical Name: :8234/spds/test/potatoes/

LIBNAME spud clear;

LIBNAME cake sasspds 'carrots' 
   server=husky.6100 
   user='bob' 
   passwd='bob123'
DISCONNECT=YES;

NOTE: Libref CAKE was successfully assigned as follows: 
      Engine:        SASSPDS 
      Physical Name: :8240/spds/test/carrots/

LIBNAME fruit sasspds 'apples' 
   server=husky.6100 
   user='bob' 
   passwd='bob123'
DISCONNECT=YES;

NOTE: Libref FRUIT was successfully assigned as follows: 
      Engine:        SASSPDS 
      Physical Name: :8240/spds/test/apples/

ENDOBS=n 

LIBNAME mydatalib sasspds 'conversion_area'
   server=husky.5105
   user='siteusr1'
   prompt=yes
   startobs=200
   endobs=500;

LIBGEN=YES 

/* The example code without LIBGEN=YES */
/* must issue execute connection       */
/* statements to access tables that    */
/* reside in two different domains.    */

LIBNAME path1 sasspds 'path1'
  server=boxer.5140
  ip=YES
  user='anonymous' ;

LIBNAME path2 sasspds 'path2'
  server=boxer.5140
  ip=YES
  user='anonymous' ;

DATA path1.table1
  (keep=i table1)
path2.table2
  (keep=i table2) ;

table1 = 'table1' ;
table2 = 'table2' ;

do i = 1 to 10 ;
  output ;
  end ;
run ;

PROC SQL ;
CONNECT to sasspds (
  dbq='Path1'
  server=boxer.5140
  user='anonymous') ;

/* Without LIBGEN=YES, you must make  */
/* two execute connect statements.    */

execute (LIBREF path1 engopt="dbq='path1'")
  by sasspds;
execute (LIBREF path2 engopt="dbq='path2'")
  by sasspds;

execute
  (create table table4 as
   select *
   from
     path1.table1 a,
     path2.table2 b
   where a.i = b.i)
 by sasspds ;

disconnect from sasspds ;

quit ;

/* The example code that uses LIBGEN=YES   */
/* can join the tables from two different  */
/* domains in a more simple manner.        */

LIBNAME path1 sasspds 'path1'
  server=boxer.5140
  LIBGEN=YES
  ip=YES
  user='anonymous' ;

LIBNAME path2 sasspds 'path2'
  server=boxer.5140
  LIBGEN=YES
  ip=YES
  user='anonymous' ;

DATA path1.table1
  (keep=i table1)
path2.table2
  (keep=i table2) ;

table1 = 'table1' ;
table2 = 'table2' ;

do i = 1 to 10 ;
  output ;
  end ;
run ;

PROC SQL ;
CONNECT to sasspds (
  dbq='Path1'
  server=boxer.5140
  user='anonymous') ;

/* Syntax used with LIBGEN=YES option */

execute
 (create table table4 as
  select *
  from
   path1.table1 a,
   path2.table2 b
  where a.i = b.i)
by sasspds ;

disconnect from sasspds ;

quit ;

LOCKING=YES|NO

     LIBNAME testrl sasspds 'tmp'
           server=serverNode.port
           user='anonymous'
           locking=YES ;

STARTOBS=n

LIBNAME mydatalib sasspds 'conversion_area'
   server=husky.5105
   user='siteusr1'
   prompt=yes
   startobs=200
   endobs=500;

TEMP=YES|NO 

LIBNAME mydatalib sasspds 'conversion_area'
   server=kaboom.5191
   user='siteusr1'
   prompt=yes
   temp=yes ;

TRUNCWARN=YES|NO 

WORKPATH=('path-specification') ;

workpath=('workspace1')

LIBNAME domain-name sasspds "domain-name"
   server=host-name.port-number
   user='user1'

workpath=('/bigdisk/spdsmgr/workpath1') ;

LIBNAME domain-name sasspds "domain-name"
   server=host-name.port-number
   user='user2'

workpath=('/bigdisk/spdsmgr/workpath2') ;