NOTE: There were 3368108 observations read from the data set TORONTO.MASTERGPI.
NOTE: The data set WORK.MASTERGPI has 3368108 observations and 70 variables.
NOTE: DATA statement used (Total process time):
      real time           1:08.35
      cpu time            7.24 seconds


689   filename iGPI ftp "'GPIP.C.M.ZGPIXTRG.MONACCUM(0)'" host='****' user="&user"
689 ! pass="&pw" recfm=f lrecl=840 rcmd='site rdw';
690   %let i= monaccum;
691   %decode;

NOTE: 220-TCPFTPD1 IBM FTP CS V2R2 at VIPAP999, 09:43:51 on 2017-04-20.
NOTE: User *** has connected to FTP server  on Host ****.
NOTE: The infile IGPI is:
      Filename='GPIP.C.M.ZGPIXTRG.MONACCUM(0)',
      Pathname= "'****'" is working directory,
      Local Host Name=****,
      Local Host IP addr=*****,
      Service Hostname Name=*****,
      Service IP addr=*****,Service Name=FTP,
      Service Portno=21,Lrecl=840,Recfm=Fixed

NOTE: 66476 records were read from the infile IGPI.
NOTE: The data set WORK.GPIMONACCUM has 66476 observations and 70 variables.
NOTE: DATA statement used (Total process time):
      real time           2.38 seconds
      cpu time            0.49 seconds


692
693   %let gpi_data = GPI&i;
694   %cleanGPI;

NOTE: There were 66476 observations read from the data set WORK.GPIMONACCUM.
NOTE: The data set WORK.GPIMONACCUM has 66476 observations and 70 variables.
NOTE: DATA statement used (Total process time):
      real time           2.29 seconds
      cpu time            0.36 seconds



NOTE: There were 66476 observations read from the data set WORK.GPIMONACCUM.
NOTE: The data set WORK.GPIMONACCUM has 66476 observations and 70 variables.
NOTE: The data set TORONTO.GPIMONACCUM has 66476 observations and 70 variables.
NOTE: DATA statement used (Total process time):
      real time           2.41 seconds
      cpu time            0.25 seconds


695
696   PROC APPEND BASE=mastergpi DATA=GPI&i;
697   RUN;

NOTE: Appending WORK.GPIMONACCUM to WORK.MASTERGPI.
NOTE: There were 66476 observations read from the data set WORK.GPIMONACCUM.
NOTE: 66476 observations added.
NOTE: The data set WORK.MASTERGPI has 3434584 observations and 70 variables.
NOTE: PROCEDURE APPEND used (Total process time):
      real time           1.83 seconds
      cpu time            0.16 seconds