Transporting SAS Libraries From Mainframe to PC

1
Transporting SAS LibrariesFrom Mainframe to PC

• December 2003

2
Transporting SAS LibrariesIn Four Easy Steps

• Find the space requirement prior to transport
• Run CPORT on the mainframe
• FTP the library in binary
• Run CIMPORT on the PC

3
Find the space requirement prior to transport

• //AUCJW3 JOB (0070173,O-PC),'INSTRESCH-SAS
  BACKUP',CLASSA,TIME1,
• // MSGCLASSQ
• //
• //
  
• // FINDING THE SPACE REQUIREMENT PRIOR TO
  TRANSPORT
• //
  
• //
  
• // EXEC ADSAS,INST'USER.UND',PRNTAQ
• //TRANSFIL DD UNITSYSDA,SPACE(CYL,(50,50))
• //SYSIN DD
• PROC CPORT LIBADMIN FILETRANSFIL MEMTYPEALL
• SELECT CRSKW004
• PROC RELEASE DDNAMETRANSFIL

4

• SAMPLE OF OUTPUT FROM SASLOG (This will give the
  tracks needed for SPACE)
• .
• .
• NOTE 750 TRACKS ALLOCATED, 719 USED, 1 EXTENTS,
  BEFORE RELEASE.
• NOTE 720 TRACKS ALLOCATED, 719 USED, 1 EXTENTS,
  AFTER RELEASE.
• NOTE The PROCEDURE RELEASE used 0.01 CPU seconds
  and 8467K.
• .
• .

5
Run CPORT on the mainframe

• Update the SPACE from previous job SASLOG
• //AUCJW3 JOB (0070173,O-PC),'INSTRESCH-SAS
  BACKUP',CLASSA,TIME1,
• // MSGCLASSQ
• //
• //
  
• // ATTEMPTING TO COPY IN FROM DISK AND
  TRANSPORT FOR FTP
• //
  
• //
  
• // EXEC ADSAS,INST'USER.UND',PRNTAQ
• //TRANSFIL DD DSNAUCJW.XPORT011.DAT,DISP(NEW,CAT
  LG),
• // UNITSYSDA,SPACE(TRK,(720,720))
• //SYSIN DD
• PROC CPORT LIBADMIN FILETRANSFIL MEMTYPEALL
• SELECT DEMO011

6

• SAMPLE OF OUTPUT FROM SASLOG
• .
• .
• NOTE Proc CPORT begins to transport data set
  ADMIN.DEMO011
• NOTE The data set contains 25 variables and
  80039 observations.
• Logical record length is 153.
• NOTE Proc CPORT begins to transport data set
  ADMIN.CRSWK011
• NOTE The data set contains 25 variables and 939
  observations.
• Logical record length is 153.
• NOTE Proc CPORT begins to transport data set
  ADMIN.TS011OC0
• NOTE The data set contains 25 variables and
  78727 observations.
• Logical record length is 153.
• .
• .
• .

7
FTP the dataset in binaryusing your procedures
for file transfer, FTP the .dat file. Be sure
you use the BINARY option.
8
Run CIMPORT on the PC

• libname admin c\sas\extracts'
• proc cimport libraryadmin infile'c\download\XPO
  RT011.DAT'
• run
• proc contents nods dataadmin._all_
• run

9
SAMPLE OF OUTPUT FROM SASLOG..NOTE Proc
CIMPORT begins to create/update data set
ADMIN.CRSWK041NOTE Data set contains 25
variables and 83408 observations. Logical
record length is 160NOTE Proc CIMPORT begins
to create/update data set ADMIN.C3SWK041NOTE
Data set contains 25 variables and 82397
observations. Logical record length is
160NOTE Proc CIMPORT begins to create/update
data set ADMIN.C3041OC1NOTE Data set contains
25 variables and 455 observations. Logical
record length is 160NOTE Proc CIMPORT begins
to create/update data set ADMIN.DEFGR041NOTE
Data set contains 3 variables and 7093
observations. Logical record length is
16..
10

• Thanks to Rick Langston, SAS
• Institute, for his help with these steps.
• Carmen Williams
• carmen.williams_at_mail.und.nodak.edu
• 701-777-2456