topic Re: merging in SAS Programming

merging

BrahmanandaRao — Tue, 26 Mar 2019 08:52:12 GMT

data t1; input x y; cards; 1 2 2 3 ; run; data t2; input x y; cards; 2 5 3 6 4 9 ; run; I want output: -------------------- x y x y 1 2 2 5 1 2 3 6 1 2 4 9 2 3 2 5 2 3 3 6 2 3 4 9

Re: merging

Patrick — Tue, 26 Mar 2019 08:51:15 GMT

@BrahmanandaRao

If you want us to spend time for you then you need to spend a bit more time for asking the question.

To post code please use one of the following icons so that things don't turn up as badly as what you're giving us.

And to address your implicit question:

You're after a Cartesian Product. That's done using a SQL JOIN. If this is homework and you've been asked to use a data step merge then it's important that you read in the documentation about joining/merging data sets and start to understand the difference between a SAS Data Step Merge and a SQL JOIN.

Re: merging

Kurt_Bremser — Tue, 26 Mar 2019 08:52:28 GMT

Please use the proper methods for posting code and results. Right now one has to guess, given your spaghetti post.

Code is best posted with the "little running man" icon, textual data and logs with the {i} button. Help us to help you, it's not rocket science.

@BrahmanandaRao wrote:
data t1; input x y; cards; 1 2 2 3 ; run; data t2; input x y; cards; 2 5 3 6 4 9 ; run; I want output: -------------------- x y x y 1 2 2 5 1 2 3 6 1 2 4 9 2 3 2 5 2 3 3 6 2 3 4 9

Re: merging

PeterClemmensen — Tue, 26 Mar 2019 08:57:18 GMT

Two variables can't have the same name in SAS. Other than that, this code gives you what you want

data t1; 
input x y; 
cards; 
1 2 
2 3 
; 
run; 

data t2; 
input x y; 
cards; 
2 5 
3 6 
4 9 
; 
run;

data want;

   set t1;

   do i=1 to n;
      set t2(rename=(x=x2 y=y2)) point=i nobs=n;
      output;
   end;

run;

proc print data=want;
run;

Result: