From: Mark Sussman on
Hi,

I need to use Federal Procurement Data for a project I'm working on
and along I'm a regular SAS user, I've never had to deal with XML
files before. I did some research and tried to use the following code
to import the XML files I have:

libname FPDS xml 'Z:\OFCCP\Raw Data\FPDS Data\1300-
COMMERCEDEPARTMENTOF-AWARD.xml';

and am getting the following errors:

ERROR: Read Access Violation In Task [ DMSEXP )
Exception occurred at (5FDF69C6)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
5FDF69C6 066BC6EC sascmxml:mcn_main+0x59C6
5FDF2593 066BC77C sascmxml:mcn_main+0x1593
62D9259F 066BC7BC saspxml:mcn_main+0x159F
5D56CF19 066BC844 tkexml:tkexml+0xBF19
5D564753 066BC8E4 tkexml:tkexml+0x3753
5D568E2C 066BC930 tkexml:tkexml+0x7E2C
5D569184 066BC95C tkexml:tkexml+0x8184
62D917B3 066BC994 saspxml:mcn_main+0x7B3
5F9B740A 066BC9B4 sasbxml:mcn_main+0x640A
5F9B6F48 066BCBE0 sasbxml:mcn_main+0x5F48
5FDFE76D 066BCC14 sascmxml:mcn_main+0xD76D
5FDF13CA 066BCC68 sascmxml:mcn_main+0x3CA
5FDF127F 066BCC78 sascmxml:mcn_main+0x27F
5FBE1492 066BCCB0 sasioxml:mcn_main+0x492
5FBF754A 066BCD30 sasexml:mcn_main+0x654A
659944F3 066BCD68 sasxdbi:mcn_main+0x234F3
6598BAD1 066BCDD4 sasxdbi:mcn_main+0x1AAD1
671CC183 066BCFF8 sasyoio:mcn_main+0x2B183
675D1D13 066BD7AC sasyui:mcn_main+0xD13
675F4F60 066BE058 saszu:mcn_main+0x13F60
675E6D54 066BE2C8 saszu:mcn_main+0x5D54
67C88DB6 066BE310 sasvwu:mcn_main+0x27DB6
67D0A799 066BE384 sasvwu:mcn_main+0xA9799
67D0A662 066BE3B4 sasvwu:mcn_main+0xA9662
67CBE922 066BE97C sasvwu:mcn_main+0x5D922
67D073AD 066BE9D8 sasvwu:mcn_main+0xA63AD
675F16FE 066BF038 saszu:mcn_main+0x106FE
675E71EE 066BF2CC saszu:mcn_main+0x61EE
656E253F 066BF360 saszculv:mcn_main+0x153F
67624080 066BF430 sasxfs:mcn_main+0x3080
67623878 066BF45C sasxfs:mcn_main+0x2878
675FE313 066BFF7C saszu:mcn_main+0x1D313
67441046 066BFF8C saszdex:mcn_main+0x46
011A2B02 066BFFA4 sashost:Main+0xBE72
011A6C20 066BFFB8 sashost:Main+0xFF90
77E6608B 066BFFEC kernel32:GetModuleFileNameA+0xEB

ERROR: Generic critical error.


This data is available for download from this website if you would
like to help me out:

https://www.fpds.gov/fpdsng_cms/index.php/archives


Thanks so much

Mark

From: Reeza on
On May 5, 11:14 am, Mark Sussman <msuss...(a)gmail.com> wrote:
> Hi,
>
> I need to use Federal Procurement Data for a project I'm working on
> and along I'm a regular SAS user, I've never had to deal with XML
> files before.  I did some research and tried to use the following code
> to import the XML files I have:
>
> libname FPDS xml 'Z:\OFCCP\Raw Data\FPDS Data\1300-
> COMMERCEDEPARTMENTOF-AWARD.xml';
>
> and am getting the following errors:
>
> ERROR:  Read Access Violation In Task [ DMSEXP )
> Exception occurred at (5FDF69C6)
> Task Traceback
> Address   Frame     (DBGHELP API Version 4.0 rev 5)
> 5FDF69C6  066BC6EC  sascmxml:mcn_main+0x59C6
> 5FDF2593  066BC77C  sascmxml:mcn_main+0x1593
> 62D9259F  066BC7BC  saspxml:mcn_main+0x159F
> 5D56CF19  066BC844  tkexml:tkexml+0xBF19
> 5D564753  066BC8E4  tkexml:tkexml+0x3753
> 5D568E2C  066BC930  tkexml:tkexml+0x7E2C
> 5D569184  066BC95C  tkexml:tkexml+0x8184
> 62D917B3  066BC994  saspxml:mcn_main+0x7B3
> 5F9B740A  066BC9B4  sasbxml:mcn_main+0x640A
> 5F9B6F48  066BCBE0  sasbxml:mcn_main+0x5F48
> 5FDFE76D  066BCC14  sascmxml:mcn_main+0xD76D
> 5FDF13CA  066BCC68  sascmxml:mcn_main+0x3CA
> 5FDF127F  066BCC78  sascmxml:mcn_main+0x27F
> 5FBE1492  066BCCB0  sasioxml:mcn_main+0x492
> 5FBF754A  066BCD30  sasexml:mcn_main+0x654A
> 659944F3  066BCD68  sasxdbi:mcn_main+0x234F3
> 6598BAD1  066BCDD4  sasxdbi:mcn_main+0x1AAD1
> 671CC183  066BCFF8  sasyoio:mcn_main+0x2B183
> 675D1D13  066BD7AC  sasyui:mcn_main+0xD13
> 675F4F60  066BE058  saszu:mcn_main+0x13F60
> 675E6D54  066BE2C8  saszu:mcn_main+0x5D54
> 67C88DB6  066BE310  sasvwu:mcn_main+0x27DB6
> 67D0A799  066BE384  sasvwu:mcn_main+0xA9799
> 67D0A662  066BE3B4  sasvwu:mcn_main+0xA9662
> 67CBE922  066BE97C  sasvwu:mcn_main+0x5D922
> 67D073AD  066BE9D8  sasvwu:mcn_main+0xA63AD
> 675F16FE  066BF038  saszu:mcn_main+0x106FE
> 675E71EE  066BF2CC  saszu:mcn_main+0x61EE
> 656E253F  066BF360  saszculv:mcn_main+0x153F
> 67624080  066BF430  sasxfs:mcn_main+0x3080
> 67623878  066BF45C  sasxfs:mcn_main+0x2878
> 675FE313  066BFF7C  saszu:mcn_main+0x1D313
> 67441046  066BFF8C  saszdex:mcn_main+0x46
> 011A2B02  066BFFA4  sashost:Main+0xBE72
> 011A6C20  066BFFB8  sashost:Main+0xFF90
> 77E6608B  066BFFEC  kernel32:GetModuleFileNameA+0xEB
>
> ERROR: Generic critical error.
>
> This data is available for download from this website if you would
> like to help me out:
>
> https://www.fpds.gov/fpdsng_cms/index.php/archives
>
> Thanks so much
>
> Mark

Doesn't SAS have an XML Parser somewhere? It's a separate install I
believe...