You should have mentioned that you had a file with all the information to read the file.   data info; infile cards dsd dlm='09'x firstobs=2; input name:$32. type:$1. length:5. (format informat)(:$32.); cards; Name Type Length Format Informat Label F1 Numeric 8 BEST1. BEST1. F2 Character 9 $CHAR9. $CHAR9. F3 Character 15 $CHAR15. $CHAR15. F4 Character 15 $CHAR15. $CHAR15. F5 Numeric 8 BEST18. BEST18. F6 Character 3 $CHAR3. $CHAR3. F7 Numeric 8 BEST1. BEST1. F8 Character 25 $CHAR25. $CHAR25. F9 Character 15 $CHAR15. $CHAR15. F10 Character 1 $CHAR1. $CHAR1. F11 Character 1 $CHAR1. $CHAR1. F12 Date 8 YYMMDD10. YYMMDD10. F13 Numeric 8 BEST1. BEST1. F14 Character 1 $CHAR1. $CHAR1. F15 Numeric 8 BEST1. BEST1. F16 Character 1 $CHAR1. $CHAR1. F17 Character 18 $CHAR18. $CHAR18. F18 Numeric 8 BEST9. BEST9. F19 Character 25 $CHAR25. $CHAR25. F20 Character 15 $CHAR15. $CHAR15. F21 Character 20 $CHAR20. $CHAR20. F22 Character 2 $CHAR2. $CHAR2. F23 Numeric 8 BEST5. BEST5. F24 Numeric 8 BEST4. BEST4. F25 Character 2 $CHAR2. $CHAR2. F26 Character 4 $CHAR4. $CHAR4. F27 Numeric 8 BEST10. BEST10. F28 Character 1 $CHAR1. $CHAR1. F29 Numeric 8 BEST1. BEST1. F30 Numeric 8 BEST18. BEST18. F31 Numeric 8 BEST7. BEST7. F32 Numeric 8 BEST7. BEST7. F33 Numeric 8 BEST7. BEST7. F34 Numeric 8 BEST7. BEST7. F35 Character 10 $CHAR10. $CHAR10. F36 Numeric 8 BEST7. BEST7. F37 Numeric 8 BEST5. BEST5. F38 Numeric 8 BEST5. BEST5. F39 Numeric 8 BEST5. BEST5. F40 Numeric 8 BEST5. BEST5. F41 Character 6 $CHAR6. $CHAR6. F42 Character 6 $CHAR6. $CHAR6. F43 Numeric 8 BEST7. BEST7. ;;;; run; proc print; run; filename stmts temp; data _null_; file stmts; set info; put 'Input ' name informat '@;'; if format in:('YYMMDD') then put +3 'Format ' name format ';'; run; data pop_data; infile "/data/Sample_data.txt"; %include stmts; run; Input F1 BEST1. @; Input F2 $CHAR9. @; Input F3 $CHAR15. @; Input F4 $CHAR15. @; Input F5 BEST18. @; Input F6 $CHAR3. @; Input F7 BEST1. @; Input F8 $CHAR25. @; Input F9 $CHAR15. @; Input F10 $CHAR1. @; Input F11 $CHAR1. @; Input F12 YYMMDD10. @; Format F12 YYMMDD10. ; Input F13 BEST1. @; Input F14 $CHAR1. @; Input F15 BEST1. @; Input F16 $CHAR1. @; Input F17 $CHAR18. @; ... View more

@jimbarbour wrote: Why not just go straight to Excel (xlsx)?  Don't use the essentially obsolete ExcelXP tag set.  Use the ODS Excel destination.  What version of SAS are you running?  Unless it's a fairly old version, you should be able to use the Excel destination.  If you use the Excel destination, then you don't need to convert XML to XLSX; you'll have XLSX directly.   This paper might be helpful: https://blogs.sas.com/content/sgf/2017/02/20/tips-for-using-the-ods-excel-destination/   Jim You might consider my suggestion of just going directly to XLSX and eliminating the XML step.  Going directly to XLSX can be fully automated.   Jim ... View more