DATA Step, Macro, Functions and more

combining datasets

Reply
Contributor
Posts: 53

combining datasets

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

 

Super User
Posts: 10,516

Re: combining datasets

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.

Ask a Question
Discussion stats
  • 1 reply
  • 169 views
  • 2 likes
  • 2 in conversation