topic Re: How to read FIXML file in New SAS User

How to read FIXML file

gskn — Tue, 02 Apr 2019 20:58:46 GMT

Hello

I am looking for any documentation regarding How to read FIXML file into SAS dataset. Can anyone please help?

Re: How to read FIXML file

andreas_lds — Sat, 06 Apr 2019 05:57:46 GMT

Never used (heard of) that file format. Is it text-format? Then reading it with a datastep is possible. Can you post some lines (using the {i} icon) and explain the contents?

Re: How to read FIXML file

gskn — Mon, 08 Apr 2019 04:09:42 GMT

This is my first time working on FIXML file.

Below are some information:

http://fixwiki.org/fixwiki/FPL:FIXML_Syntax

example data below:

<MyRpt RptID="ABCD1234" Dt="2019-03-07"><Pty ID="SAM" RI="A21" /><Pty ID="00615" RI="B41" > <Sub ID="C" Typ="26"/></Pty><Instrmt Sym="IBM" CID="ABCDEF" MMY="20190308" MatDt="2019-03-08" Price="40" Curr="USD" Mult="100"/><Qty Typ="AS" Short="2"/><Amt Typ="SELL" Amt="8000"/></MyRpt>