Positioning data elements from excel file in SAS to create a text file with no delimiters

[jakarman]

Ashwini when you are not sure about syntax, check the manuals.

The Termstr is a indicator for which character convention as end of record or newline is used. Windows and Unix are behaving different. SAS(R) 9.4 Companion for Windows, Third Edition  (input)
if you are wanting to code a fixed recordlength use the lrec= option SAS(R) 9.4 Statements: Reference, Third Edition (input)

What went wrong with 99/100?

I am seeing a - (hyphen) in your code. It could be interpreted as going back one postion. You where at 100 and then moving back one. It is not documented SAS(R) 9.3 Statements: Reference moving the pointer is +(-1) or #101.

As the record length is not really fixed, you should be at a mainframe for those options,  but indicates by characterstring it is rather arbitrary to check that.

Most tools do no show control-characters as a binary stream. I do not know of any tool showing really clearly spaces (there are meant to be blank/invisible.        

[Ashwini_uci]

Thanks Jaap! No, theres isn't any hyphen in my code, I just used it here to separate the code from the text.

My other question is, if i shoud just go by what the SAS log says after converting the SAS file to text file. The SAS log file indicates that the

The minimum record length was 100.

The maximum record length was 100.

So I think I should just go by what the log says, even though my manual counting shows 101 positions.

And as Indicated in the NDI guidelines, the text file should be with 100 postions per record..