topic Re: Read Outlook MSG file into SAS in SAS Programming

Read Outlook MSG file into SAS

Ja5ya — Tue, 13 Oct 2020 05:24:45 GMT

Hi, I'm trying to read in MSG file into SAS but wasn't able to do so.

Then I tried using LINUX command, I got it to convert to txt file but it wasn't readable by SAS. I used code like:

data _null_;

x "cd /source/data/";

x "rename .msg .txt *.msg";

run;

Can anyone help me in trying to read the Outlook MSG file from SAS? I'm ok with converting the msg file too into txt file but it should be SAS Readable.

Please help.

Re: Read Outlook MSG file into SAS

vellad — Tue, 13 Oct 2020 05:46:13 GMT

You need to download the Outlook messages as .txt files and not .msg files. You can't just rename an .msg file as .txt and expect it to behave as .txt, because .msg has its own encoding rules and is not a simple flat file like a .txt file.
If you can't create the .txt files from scratch, you can download and use a utility such as this one to read the .msg files.

Re: Read Outlook MSG file into SAS

KS4NCS — Tue, 13 Oct 2020 08:10:58 GMT

Hi Ja5ya,
You can use this python tool also to extract txt from msg file.
https://github.com/TeamMsgExtractor/msg-extractor
Hope this help.

Re: Read Outlook MSG file into SAS

Ja5ya — Fri, 16 Oct 2020 07:23:00 GMT

Thanks. I'm looking into it.

Re: Read Outlook MSG file into SAS

SASKiwi — Sat, 17 Oct 2020 23:19:30 GMT

As a test, you can do a "File Save As" on an Outlook message you have opened.