Yes, sorry for delay. I have not bothered yet to name all the variables for this since the last 3 variables or columns are are the only ones that I am having issues with. Thanks for taking the time to help. Here is a copy of the log: /* -------------------------------------------------------------------- Code generated by a SAS task Generated on Saturday, July 02, 2011 at 4:00:32 PM By task: Import Data Source file: E:\David's Documents\Clients\Stats\Data\Data query - Run\reports\file1.CSV Server: Local File System Output data: WORK.file1 Server: Local -------------------------------------------------------------------- */ DATA WORK.AA_HT1; LENGTH F1 8 F2 8 F3 $ 6 F4 $ 3 F5 $ 1 F6 8 F7 8 F8 $ 3 F9 $ 3 F10 $ 3 CAT 8 GAM 8 SAL 8 ; FORMAT F1 BEST10. F2 BEST18. F3 $CHAR6. F4 $CHAR3. F5 $CHAR1. F6 YYMMDD10. F7 DDMMYY10. F8 $CHAR3. F9 $CHAR3. F10 $CHAR3. CAT BEST9. GAM BEST10. SAL BEST10. ; INFORMAT F1 BEST10. F2 BEST18. F3 $CHAR6. F4 $CHAR3. F5 $CHAR1. F6 YYMMDD10. F7 DDMMYY10. F8 $CHAR3. F9 $CHAR3. F10 $CHAR3. CAT BEST9. GAM BEST10. SAL BEST10. ; INFILE 'C:\Users\David\AppData\Local\Temp\SEG1844\file1-bd5b8ded924346ca9b53f0e328e93c43.txt' LRECL=98 ENCODING="WLATIN1" TERMSTR=CRLF DLM='7F'x MISSOVER DSD ; INPUT F1 : ?? BEST10. F2 : ?? BEST18. F3 : $CHAR6. F4 : $CHAR3. F5 : $CHAR1. F6 : ?? YYMMDD8. F7 : ?? DDMMYY6. F8 : $CHAR3. F9 : $CHAR3. F10 : $CHAR3. CAT : ?? COMMA9. GAM : ?? COMMA10. SAL : ?? COMMA10. ; RUN;
... View more