Hi,   I am reading huge xml files using xmlv2 libname and xmlmapper file. After reading the each file, I need to add a source filename to the output dataset. I can not use INDSNAME option because I must use PROC APPEND.   Because my source file has missing columns or additional new columns every time. This can be done only using PROC APPEND with FORCE option. Hence kindly guide me how can I add a new column in PROC APPEND?   Thanks Arun     ... View more

Thanks a lot for the quick response. Let me explain the background. We were using Talend to ingest xml files to MS Sql server from here we were reading in SAS Eminer to build models. Myself only suggested client,we can use SAS DI it is powerful DI tool.Now client is asking why cant we use just a transformation to read xml file like in talend,in talend ita simple..we use one transformation tInputXML and configure settings. My client is expecting same process,he do not want to write code. Thanks Arun +65-91286603 ... View more

Hi Matt, Did you found a best solution to read xml using SAS DI? i am also facing same issues..not able to find a best solution except using xml libname...Thanks ... View more