So, I have different folders that contain more than 300 files: Some folders have tab delimited and some have fixed width. Suppose file 1 has jane 45 4RT M john 23 4GJT M file2: george 23 3DFE 1J M jake 54 4KL 1K M I want to append File 1 and file 2 where I want to add 4th column which shows null for file 1 but 1J, 1K for file 2. My codes looks like this: data new; infile " path* " delimiter = '09'x MISSOVER DSD; informat name $10. age 2. res_num $7. idnum $2. gender $1. format name $10. age 2. res_num $7. idnum $2. gender $1. input name $10. age 2. res_num $7. idnum $2. gender $1. ; run; If I run this, there's no separate column created instead the 5 column is copied and breaks further column's data. How should I approach this? Thanks
... View more