I receive the same error for uploaded CSV and TXT file versions I upload from the PC to TSO ISPF using the SEND utility The difference between CSV/TXT/PRN files is comma/tab(dot)/right justified between data columns Log: NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) 9.1 (TS1M3) Licensed to LOUISIANA STATE UNIVERSITY, Site 0001407001. NOTE: This session is executing on the z/OS V01R10M00 platform. NOTE: Running on IBM Model 2818 Serial Number 0177A7, IBM Model 2818 Serial Number 0177A7, IBM Model 2818 Serial Number 0177A7. NOTE: SAS 9.1.3 Service Pack 2 Welcome to SAS 9.1.3 SSS AAA SSS 999 I 333 S S A A S S 9 9 II 3 3 S A S 9 9 I 3 S A S 9 9 I 3 S AAAA S 9999 I 333 S A A S 9 I 3 S S A A S S 9 I 3 S S A A S S 9 0 I 0 3 3 SSS AAAAA SSS 99 0 III 0 333 Please report SAS problems to the ITS Help Desk at 225-578-3375 or by email to helpdesk@lsu.edu. NOTE: The SASUSER library was not specified. SASUSER library will now be the same as the WORK library. NOTE: All data sets and catalogs in the SASUSER library will be deleted at the end of the session. Use the NOWORKTERM option to prevent their deletion. NOTE: SAS system options specified are: SORT=4 NOTE: 101187584 bytes were available above the line at initialization. NOTE: 6815744 bytes were available below the line at initialization. NOTE: 100663296 bytes were available above the line after adjustment for MEMLEAVE=524288. NOTE: The initialization phase used 0.06 CPU seconds and 6481K. NOTE: The address space has used a maximum of 648K below the line and 7604K above the line. 1 ********************************************************************; 2 * PROGRAM: FAD7079S *; 3 * DESCRIPTION: THIS PROGRAM LOADS THE FAD.PELL_SCHEDULE DB2 *; 4 * TABLE FROM AN EXCEL CSV INPUT FILE THAT CONTAINS *; 5 * PELL SCHEDULE DATA FROM THE DEPT OF US EDUCATION *; 6 * *; 7 * AUTHOR: DONNA EICHER/BOROVY *; 8 * DATE WRITTEN: NOVEMBER 2014 *; 9 * INPUT: FAD.PROD.FAD7079.PELLSCHD.LOAD CSV INPUT FILE *; 10 * OUTPUT: REPORT OF NEW PELL SCHEDULE ENTRIES *; 11 * ERROR REPORT *; 12 ********************************************************************; 12 The SAS System 13:45 Tuesday, February 3, 13 * CHANGED ANALYST REQ# DESCRIPTION OF CHANGE *; 14 * 11/XX/2014 BOROVY 16906 NEW *; 15 ********************************************************************; 16 17 *LIBNAME FAD DB2 AUTHID=FAD SSID=DB2; 18 *OPTIONS DB2SSID=DB2; 19 20 LIBNAME FAD DB2 AUTHID=FAD SSID=DB2T; NOTE: Libref FAD was successfully assigned as follows: Engine: DB2 Physical Name: DB2T 21 OPTIONS DB2SSID=DB2T ; 22 23 DATA PELLSCHD_IN_PRN_FORMAT; 24 INFILE INSFILE ; 25 26 INPUT @5 FINYR $4. 27 @10 MINEFC 7.0 28 @18 MAXEFC 7.0 29 @28 PELLAMTF 5.0 30 @36 PELLAMTQ 5.0 31 @44 PELLAMTH 5.0 32 @52 PELLAMTL 5.0 ; 33 RUN; NOTE: The infile INSFILE is: Dsname=BOROVY.PELL.SCHEDULE.PRN, Unit=3390,Volume=SCR003,Disp=SHR,Blksize=6160, Lrecl=80,Recfm=FB NOTE: 54 records were read from the infile INSFILE. NOTE: The data set WORK.PELLSCHD_IN_PRN_FORMAT has 54 observations and 7 variables. NOTE: The DATA statement used 0.01 CPU seconds and 7653K. NOTE: The address space has used a maximum of 712K below the line and 8896K above the line. 34 35 PROC PRINT DATA=PELLSCHD_IN_PRN_FORMAT ; 36 NOTE: There were 54 observations read from the data set WORK.PELLSCHD_IN_PRN_FORMAT. NOTE: The PROCEDURE PRINT printed page 1. NOTE: The PROCEDURE PRINT used 0.02 CPU seconds and 7924K. NOTE: The address space has used a maximum of 712K below the line and 9144K above the line. 37 PROC SORT DATA=PELLSCHD_IN_PRN_FORMAT; BY FINYR MINEFC MAXEFC ; 38 NOTE: There were 54 observations read from the data set WORK.PELLSCHD_IN_PRN_FORMAT. NOTE: The data set WORK.PELLSCHD_IN_PRN_FORMAT has 54 observations and 7 variables. NOTE: The PROCEDURE SORT used 0.00 CPU seconds and 8238K. NOTE: The address space has used a maximum of 712K below the line and 9460K above the line. 13 The SAS System 13:45 Tuesday, February 3, 39 PROC PRINT DATA=PELLSCHD_IN_PRN_FORMAT ; 40 41 *** LOAD SORTED INPUT DATA TO FAD.PELL_SCHEDULE ; 42 NOTE: There were 54 observations read from the data set WORK.PELLSCHD_IN_PRN_FORMAT. NOTE: The PROCEDURE PRINT printed page 2. NOTE: The PROCEDURE PRINT used 0.00 CPU seconds and 8238K. NOTE: The address space has used a maximum of 712K below the line and 9460K above the line. 43 PROC DB2UTIL 44 DATA = PELLSCHD_IN_PRN_FORMAT 45 TABLE = FAD.PELL_SCHEDULE 46 COMMIT = 50 47 LIMIT = 1000 48 FUNCTION = INSERT; 49 MAPTO 50 FINYR = FIN_YEAR 51 MINEFC = MIN_EFC 52 MAXEFC = MIN_EFC 53 PELLAMTF = PELL_AMOUNT_F 54 PELLAMTQ = PELL_AMOUNT_Q 55 PELLAMTH = PELL_AMOUNT_H 56 PELLAMTL = PELL_AMOUNT_L ; 57 58 UPDATE; 59 RUN; ERROR: Input map and input data do not match, procedure terminated. +ERROR: Input map and input data do not match, procedure terminated. +ERROR: Input map and input data do not match, procedure terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: The PROCEDURE DB2UTIL used 0.01 CPU seconds and 8321K. NOTE: The address space has used a maximum of 716K below the line and 9552K above the line. 60 61 ERROR: Errors printed on page 3. +ERROR: Errors printed on page 3. +ERROR: Errors printed on page 3. NOTE: The SAS session used 0.14 CPU seconds and 8321K. NOTE: The address space has used a maximum of 716K below the line and 9552K above the line. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
... View more