Hi All, we are facing one issue regarding the data with the dlm format please suggest some solution about the below query input file : ++++++++++++++++++++++++++++++++++++++++++++++++ 0230533124,,,,, 0220212484,Y,N,Y,N,N 0401092276,N,Y,N,S,J 0401104968,N,Y,N,S,J 0401108573,N,Y,N,S,J 0401132109,N,Y,N,S,J total 6 fields ++++++++++++++++++++++++++++++++++++++++++++++++++ the reqirment is 0230533124, , , , , 0220212484,Y ,N ,Y ,N ,N 0401092276,N ,Y ,N ,S ,J 0401104968,N ,Y ,N ,S ,J 0401108573,N ,Y ,N ,S ,J 0401132109,N ,Y ,N ,S ,J with the comma sapreter and one space for each field +++++++++++++++++++++++++++++++++++++++++++++++++ and plz find the below code DATA S_FRMT; FORMAT TEST1 Z10.; INFILE CLSTA2C MISSOVER DSD DLM=',' TRUNCOVER; INPUT TEST1 $ TEST2 $ TEST3 $ TEST4 $ TEST5 $ TEST6 $ ; RUN; DATA IHUB_FT; SET S_FRMT; FILE SYSOUT; putTEST2 z10. TEST3 $char1. TEST4 $char1. TEST5 $char1. TEST6 $char1.; RUN; PROC PRINT DATA = IHUB_FT; RUN; But I am facing the issue that is all fields are concatenating without comma it printing the data and i tried with the ||','|| option also that case some fields are missing my requirement is with comma separator i req the data, please kindly give some solution for the above problem Thanks & Regards Rohit
... View more
