topic Re: Text File Import Having MT940 Formatted Data in SAS Programming

Text File Import Having MT940 Formatted Data

AtulyaSharma — Wed, 27 Nov 2019 10:35:01 GMT

Hi All,

Can any one please help me in importing data from a .txt file having MT940 formatted data or we can say MT940 Bank Statement.

I want to create data sets from the file.

Please let me know if required more information.

Thanks in advance.

Atulya Sharma

Re: Text File Import Having MT940 Formatted Data

Kurt_Bremser — Wed, 27 Nov 2019 14:47:04 GMT

You will need to grab a description of the MT940 standard, and then apply that.

Wikipedia led me to this: https://web.archive.org/web/20160725042101/http://www.societegenerale.rs/fileadmin/template/main/pdf/SGS%20MT940.pdf

From what I have seen, some parts of the design are (IMHO) simply idiotic. e.g. numeric fields without a fixed length, where you have to go looking or the first non-numeric character first to determine the end of the field. So be prepared for some good ol' B,S,T&T.