topic ERROR: Input map and input data do not match, procedure terminated. in SAS Procedures

ERROR: Input map and input data do not match, procedure terminated.

borovy — Tue, 03 Feb 2015 16:54:13 GMT

I have done considerable research and cannot resolve the error in the subject line. My data is coming from an excel spreadsheet uploaded to the mainframe as a PRN file.

I want to insert the data to an existing mainframe DB2 table with the following layout:

FIN_YEAR CHAR(4) PRIM

MIN_EFC DEC(7,0) PRIM

MAX_EFC DEC(7,0) PRIM

PELL_AMOUNT_F DEC(5,0)

PELL_AMOUNT_Q DEC(5,0)

PELL_AMOUNT_H DEC(5,0)

PELL_AMOUNT_L DEC(5,0)

Sample data:

2016 801 900 4925 3694 2463 1231

2016 901 1000 4825 3619 2413 1206

2016 1001 1100 4725 3544 2363 1181

4801 4900 925 694 0 0

4901 5000 825 619 0 0

5001 5100 725 0 0 0

5101 5198 626 0 0 0

5199 999999 0 0 0 0

SAS code:

LIBNAME FAD DB2 AUTHID=FAD SSID=DB2T

OPTIONS DB2SSID=DB2T ;

DATA PELLSCHD_IN_PRN_FORMAT;

INFILE INSFILE ;

INPUT @5 FINYR $4.

@10 MINEFC 7.0

@18 MAXEFC 7.0

@28 PELLAMTF 5.0

@36 PELLAMTQ 5.0

@44 PELLAMTH 5.0

@52 PELLAMTL 5.0 ;

RUN;

PROC DB2UTIL

DATA = PELLSCHD_IN_PRN_FORMAT

TABLE = FAD.PELL_SCHEDULE

COMMIT = 50

LIMIT = 1000

FUNCTION = INSERT;

MAPTO

FINYR = FIN_YEAR

MINEFC = MIN_EFC

MAXEFC = MIN_EFC

PELLAMTF = PELL_AMOUNT_F

PELLAMTQ = PELL_AMOUNT_Q

PELLAMTH = PELL_AMOUNT_H

PELLAMTL = PELL_AMOUNT_L ;

UPDATE;

RUN;

I am willing to do additional research on my own but i have run out of ideas for where to look.

Many thanx in advance for your help....

Re: ERROR: Input map and input data do not match, procedure terminated.

LinusH — Tue, 03 Feb 2015 19:32:19 GMT

A full log will, so we can see in which step you get the error.

And, PRN file? Is that a print file?

Doesn't sound like somthing I would touch for data manipulation.

Is the a manual upload process? Why not use TAB or CSV instead?

Re: ERROR: Input map and input data do not match, procedure terminated.

borovy — Tue, 03 Feb 2015 19:56:11 GMT

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: 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 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 ********************************************************************;

17 *LIBNAME FAD DB2 AUTHID=FAD SSID=DB2;

18 *OPTIONS DB2SSID=DB2;

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 ;

23 DATA PELLSCHD_IN_PRN_FORMAT;

24 INFILE INSFILE ;

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.

35 PROC PRINT DATA=PELLSCHD_IN_PRN_FORMAT ;

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 ;

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 ;

41 *** LOAD SORTED INPUT DATA TO FAD.PELL_SCHEDULE ;

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 ;

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.

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.

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

Re: ERROR: Input map and input data do not match, procedure terminated.

ballardw — Tue, 03 Feb 2015 23:12:37 GMT

Are there any variables in the table FAD.PELL_SCHEDULE not mapped to a SAS variable?

Re: ERROR: Input map and input data do not match, procedure terminated.

borovy — Wed, 04 Feb 2015 13:04:14 GMT

well everyone, thanx for taking time to look at this issue....but i messed up, so call me embarrassed

the table as a field called MAX_EFC, in the code, i have it labeled as MIN_EFC. i've looked at this for days and just didnt see it.

again, thank you for your time.....