ERROR related to one of the Input files
Posted: Fri Jan 29, 2010 1:33 pm
First I thank so much Ray and Julio for replying my previous question. I am doing the match to see what happen.
I get an error related to one of the input file. Another file is not mentioned in error log. Experts please help again.
1) in sas program, I created the text file from a sas dataset as following:
filename outds1 "/path/matchssa/KP123109" lrecl=126;
format aRow $126.; /* (obs=100) */
substr(aRow, 1, 1)=srckp;
..... /* there are missing values */
substr(aRow, 20,35)=lnameq; /* last name */
.....
substr(aRow, 126,1)="0"; /* All row ended at the same place*/
FILE outds1;
PUT aRow;
Program is submitted from window XP to UNIX to be execute.
2) in QS match setting, all "Missing Value"are 'S', all f"Feld type" are 'S', all "field data type" are 'A'. I also have two additional varibles read on last name and first name from byte 1 to byte 4. The "Start/End/length" are corrctly set.
3) [b]ERROR[/b]:
Error exec: /emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.MTC.StepFREQLDA.log:freqld(20194):Fri 29 Jan 2010 10:45:04 AM PST (MSG_vio.c:12; vio.c:1516) ERROR: Incomplete record read from file /emc-nas/user/x966892/QSProjects/NEWGS/Data/KP123109
/emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.MTC.StepFREQLDA.log:freqld(20194):Fri 29 Jan 2010 10:45:04 AM PST (MSG_vio.c:13; vio.c:1518) ERROR: len=126, BufCnt=100, BufSize=102400, HaveCnt=100, readCnt=0, readRtn=0
/emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.MTC.StepFREQLDA.log:freqld(20194):Fri 29 Jan 2010 10:45:04 AM PST (MSG_vutils.c:13; vutils.c:1412) ERROR: vexit status=1
/emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.Step001.log:ERROR: freqld FAILED (1)
Op Failed Step001 (1)
EXITVAL=1 /* in step 1, block/match vars have missings values */
4) [b]KP123109.DIC:[/b]
;;QualityStage v7.0
RECORD 125
FILE ${DATAA}
CODEPAGE DEFAULT
FILEFORMAT FIXEDTERM
VAR LSONDEX 105 8 S A
VAR FSONDEX 113 8 S A
VAR SRCKP 1 1 S A
VAR SRCINDE 2 9 S A
VAR SSNKP 11 9 S A
VAR LNAME 20 35 S A
VAR FNAME 55 25 S A
VAR MNAME 80 1 S A
VAR DOBYR 81 4 S A
VAR DOBMN 85 2 S A
VAR DOBDY 87 2 S A
VAR LNYSIIS 89 8 S A
VAR FNYSIIS 97 8 S A
VAR ZIPKP 121 5 S A
VAR LNAME4C 20 4 S A
VAR FNAME4C 55 4 S A
Any instruction is welcome. Do I need to do more to handle missing value and line endding? how?
thanks in advance.
I get an error related to one of the input file. Another file is not mentioned in error log. Experts please help again.
1) in sas program, I created the text file from a sas dataset as following:
filename outds1 "/path/matchssa/KP123109" lrecl=126;
format aRow $126.; /* (obs=100) */
substr(aRow, 1, 1)=srckp;
..... /* there are missing values */
substr(aRow, 20,35)=lnameq; /* last name */
.....
substr(aRow, 126,1)="0"; /* All row ended at the same place*/
FILE outds1;
PUT aRow;
Program is submitted from window XP to UNIX to be execute.
2) in QS match setting, all "Missing Value"are 'S', all f"Feld type" are 'S', all "field data type" are 'A'. I also have two additional varibles read on last name and first name from byte 1 to byte 4. The "Start/End/length" are corrctly set.
3) [b]ERROR[/b]:
Error exec: /emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.MTC.StepFREQLDA.log:freqld(20194):Fri 29 Jan 2010 10:45:04 AM PST (MSG_vio.c:12; vio.c:1516) ERROR: Incomplete record read from file /emc-nas/user/x966892/QSProjects/NEWGS/Data/KP123109
/emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.MTC.StepFREQLDA.log:freqld(20194):Fri 29 Jan 2010 10:45:04 AM PST (MSG_vio.c:13; vio.c:1518) ERROR: len=126, BufCnt=100, BufSize=102400, HaveCnt=100, readCnt=0, readRtn=0
/emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.MTC.StepFREQLDA.log:freqld(20194):Fri 29 Jan 2010 10:45:04 AM PST (MSG_vutils.c:13; vutils.c:1412) ERROR: vexit status=1
/emc-nas/user/x966892/QSProjects/NEWGS/logs/KPSSAM1.Step001.log:ERROR: freqld FAILED (1)
Op Failed Step001 (1)
EXITVAL=1 /* in step 1, block/match vars have missings values */
4) [b]KP123109.DIC:[/b]
;;QualityStage v7.0
RECORD 125
FILE ${DATAA}
CODEPAGE DEFAULT
FILEFORMAT FIXEDTERM
VAR LSONDEX 105 8 S A
VAR FSONDEX 113 8 S A
VAR SRCKP 1 1 S A
VAR SRCINDE 2 9 S A
VAR SSNKP 11 9 S A
VAR LNAME 20 35 S A
VAR FNAME 55 25 S A
VAR MNAME 80 1 S A
VAR DOBYR 81 4 S A
VAR DOBMN 85 2 S A
VAR DOBDY 87 2 S A
VAR LNYSIIS 89 8 S A
VAR FNYSIIS 97 8 S A
VAR ZIPKP 121 5 S A
VAR LNAME4C 20 4 S A
VAR FNAME4C 55 4 S A
Any instruction is welcome. Do I need to do more to handle missing value and line endding? how?
thanks in advance.