topic Concatenate XML files in SAS Programming

Concatenate XML files

UdayGuntupalli — Wed, 22 Aug 2018 18:37:34 GMT

All,
If I have 2 SAS datasets that are stored as XML files, how can I concatenate them ?

libname XMLData xmlv2 '/data/Test.xml';

data Work.TestACMod;
	set Work.TestAC;
	format ReadTime datetime.;
run;

data XMLData.TestAC;
	Set Work.TestACMod;
run;

libname XMLData1 xmlv2 '/data/Test1.xml';

data Work.TestSiteDet;
	set Work.Sit;
	format CoDate datetime.;
run;

data XMLData1.TestSiteDet;
	set Work.TestSiteDet;
run;

Re: Concatenate XML files

SuryaKiran — Wed, 22 Aug 2018 18:53:02 GMT

Just as if you were concatenating SAS Datasets.

data want;
set XMLData.TestAC XMLData1.TestSiteDet;
run;

Re: Concatenate XML files

Reeza — Wed, 22 Aug 2018 19:17:28 GMT

I think you'll need a SQL join. You say concatenate but based on my knowledge of XML it looks like it was parsed to multiple tables and you want to combine them again. We can't tell you how to join it without more information on the data, specifically the logic to link it.

If I'm incorrect, one of the other users solution will work for you.

@UdayGuntupalli wrote:

All,
If I have 2 SAS datasets that are stored as XML files, how can I concatenate them ?

libname XMLData xmlv2 '/data/Test.xml';

data Work.TestACMod;
	set Work.TestAC;
	format ReadTime datetime.;
run;

data XMLData.TestAC;
	Set Work.TestACMod;
run;

libname XMLData1 xmlv2 '/data/Test1.xml';

data Work.TestSiteDet;
	set Work.Sit;
	format CoDate datetime.;
run;

data XMLData1.TestSiteDet;
	set Work.TestSiteDet;
run;