Read the input text file into a SAS dataset.
Specify the desired name of the ouput data set in the output.
The output set could then exported to a text file or reports run on the output data.
... View more
Are you getting any error messages in the log? If so post them.
You may also want to set the Option mprint; before running the code so that warnings and errors are placed in context with code generated by macros.
... View more