combining datasets

[ArchanaSudhir]

Hi,

I need to combine the following 3 datasets based on parameters - treatment, x, y.

I thought of giving a sort oder for each dataset and using Union Corr. But not sure if it is the right way.

Data1			Grade1
treatment	x
sugar	ab		2
bp	cd		3
Data2
treatment	x	y	Grade1
sugar	ab	nausea	2
sugar	ab	headache	1
bp	cd	jaundice	3
Data3
treatment	x	y	z	Grade1
sugar	ab	nausea	vomit	2
sugar	ab	nausea	dizziness	4
sugar	ab	headache	tummy pain	1
bp	cd	jaundice	fever	1
bp	cd	jaundice	hig temp	3
Output:
treatment	x	y	z	Grade1
sugar	ab			2
sugar	ab	nausea		2
sugar	ab	nausea	vomit	2
sugar	ab	nausea	dizziness	4
sugar	ab	headache		1
sugar	ab	headache	tummy pain	1
bp	cd			3
bp	cd	jaundice		3
bp	cd	jaundice	fever	1
bp	cd	jaundice	hig temp	3

How do I achieve this?

Thanks,

Archana

[ballardw]

How import is that exact order? If the idea is to group by treatment, x, y, z then

data want;

    set data1 data2 data3;

run;

proc sort data=want;

   by treatment x y Grade1 z;

run;

may get you close.