Problems Importing Text File; Wizard-Generated Code Doesn't Work When Modifying Path File

[ballardw]

I was very surprised to generated code with  dlm='7F'x.  That character is sometimes referred to as a delete character and not very displayable. I would not be surprised to find out that however that got into the code as a delimiter that the body of the data did not actually have those characters between fields. Which would mean that none of the variable would be read correctly and all the variables blank as shown. That you marked @Reeza's solution as correct where hers used a comma for the delimiter is an indication that may be a major player in this issue.

I would be tempted to send the file, the generated code and the options you used in the Wizard to tech support to see if they can determine what happened.

Another thing is ?? suppresses data error messages. It is possible that removing the ?? might have created some messages that indicate something related to what is happening.

[Reeza]

@ballardw A question from @Liz_Perkin seems to have generated very similar code using EG again. I wonder if SAS made a change somewhere that isn't generating correct code in M6? or EG?

@dbcrow I would definitely consider sending this to SAS Tech Support.