topic How can we create an XML file using SAS DI 4.2 in SAS Data Management

How can we create an XML file using SAS DI 4.2

blindgaurdien16 — Fri, 03 Feb 2012 18:00:53 GMT

Hi All,

My query is to export a CSV file into an XML file with direct one to one mapping with no transformation,

but unfortunately i am getting some problems at the last step during the XML creation.

After the XML writer, i am creating an XML library and mapping a table for the same.

Still not able to populate the XML.

Please Suggest an ALTERNATE opinion for this, if this is not right !!

Regards

Prakash

How can we create an XML file using SAS DI 4.2

blindgaurdien16 — Sat, 04 Feb 2012 10:56:31 GMT

A simple process flow will help, please help.

How can we create an XML file using SAS DI 4.2

Grandhi4 — Thu, 23 Feb 2012 20:31:22 GMT

First you have to create a 'XML library' ex:- 'SAS library' in "New Library Wizard" (last but one 'if using 4.2 ver ) then

1) Then give 'Libref' name

2) Then Path 'where you want to save the file' (ex: C:\work\Append.xml) [ Append data set should be there in that folder that data set 'columns & dataset' only u have to use as a source]

3) Select 'XML Type' -----> ''GENERIC''

4) Create a job

5) Create a new table

6) DBMS ------> 'XML-All Douments'

7) Library ------> what u created on point '1'

😎 Fallow the point '2'

9) Drag 'Append data set'

10) Drag 'XML Writer'

11) Drag out put dataset (Target table data set)

12) Map 'Source to ---------->XML Writer ---------->Target data set

13) F3 (Run)

Done u can see the XML file on the path

thx

Suresh

How can we create an XML file using SAS DI 4.2

blindgaurdien16 — Fri, 24 Feb 2012 08:38:52 GMT

Hi Suresh,

First thanks for this Job flow, but i managed to create this Job flow and now facing some issues with XSD.

I need to create my XML based on a XSD.

In the XML library i have created, i have mapped the SCHEMA(XSD) for the same in the advanced options.

But while the job is running i seem to be facing this error

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 1 observations read from the data set WORK.W63UAVD1.

WHERE BrokerRef in ('ABCD1234', 'ABCD1235', 'ABCD1236', 'ABCD1237', 'ABCD1238');

NOTE: There were 5 observations read from the data set WORK.W63UBJOQ.

NOTE: There were 1 observations read from the data set WORK.W63TUS5B.

WARNING: The data set LIB_OUT.TAB_AGENCY may be incomplete. When this step was stopped there were 0

observations and 22 variables.

Segmentation Violation In Task [ DATASTEP ]

2006

2007 %perfstop(metrVal6=%sysfunc(max(&etls_recnt,-1)));

MACROGEN(PERFSTOP): options notes nosource nosource2 nosymbolgen nomprint nomlogic

42,285+05:1800| _DISARM|

SAS_Data_Integration_Studio| _DISARM| SAS| _DISARM| -1| _DISARM| 12619776| _DISARM| 11571200|

_DISARM| 12| _DISARM| 12|

_DISARM| 0| _DISARM| 0| _DISARM| 0.040000| _DISARM| 0.072680| _DISARM| 1645610082.213303| _DIS

ARM| 1645610082.285983|

_DISARM| 0.072680| _DISARM| | _ENDDISARM

Do you have any idea rgd this SEGMENT VIOLATION in TASK and have you tired creating an XML using XSD ?

Any pointers to this will be of great HELP !!

Thanks

Prakash Ramesh