Hi Kurt here is my code so all data pull in fine except the last field which after running the below code, goes straight to the next row on table, even before i used your suggestion i was having this issue. code below %connect(os1,username,password); RSUBMIT; LIBNAME T '&&TEMP' DISP=(NEW,CATLG,DELETE) UNIT=(SYSALLDA,40) SPACE=(TRK,(60000,10000),RLSE); ------------------------------------------------------------------------------------------------------------------------------------------------------------------ DATA T.TMP_DATA; INFILE "EXA1.AA.AAAAD.AVA1333.DAT" lrecl=3513 OBS=60 ; input name $ebcdic4. location_code $ebcdic4. city_code $ebcdic3. desc_length s370fpib2. description $ebcdic3500. ; substr(description,desc_length+1) = ' '; drop desc_length; run; --------------------------------------------------------- ENDRSUBMIT; LIBNAME RWORK SLIBREF=T SERVER=REMOTE; ----------------------------------------------------------------------------------------------------------------------------------- PROC DATASETS; COPY IN = RWORK OUT = WORK; SELECT TMP_DATA; QUIT; ---------------------------------------------------------------------------------------------------------------------------------- RUN; SIGNOFF; ----------------------------------------------------------------------------------------------------------------------------------
... View more