topic Re: Using data merge what will be the various type of output in New SAS User

Using data merge what will be the various type of output

animesh123 — Fri, 16 Sep 2022 08:04:11 GMT

Id amt Id amt2

1 1000 1 100
1 2000 1 200
1 3000. 2 300
2 4000. 2 400
2 5000. 2 500

What will be the output if we use various type of Data merge statement?

Re: Using data merge what will be the various type of output

PeterClemmensen — Fri, 16 Sep 2022 09:33:23 GMT

See the Merge Statement Documentation.

Re: Using data merge what will be the various type of output

Astounding — Fri, 16 Sep 2022 09:38:00 GMT

In a DATA step, the MERGE statement combines two or more SAS data sets. You have only shown one SAS data set. So you will need to show more about what you are trying to do ... what should the other data set look like? What would you like the result to be.

Re: Using data merge what will be the various type of output

ballardw — Fri, 16 Sep 2022 17:08:28 GMT

Is that two data sets? Note really a very clear example.

Are you referring to a Data step Merge statement?

If so, you might get better results in showing what you want from them instead of "what can you get" because things like data set options can change variable names or drop variables.

Sorts that occur before the Merge can have a lot of impact on the result.

Match merge with BY variable(s) often do not behave as expected or desired when the by variables have multiple values it two or more data sets.

Re: Using data merge what will be the various type of output

Kurt_Bremser — Fri, 16 Sep 2022 17:15:53 GMT

@animesh123 wrote:
Id amt Id amt2

1 1000 1 100
1 2000 1 200
1 3000. 2 300
2 4000. 2 400
2 5000. 2 500

What will be the output if we use various type of Data merge statement?

Since you want to use "various" types without giving further details, all I can say is that you'll get equally various outputs.

Also see Maxim 42.

What will be the various types of output if we merge ID1(a) and ID2 (b)

animesh123 — Sat, 17 Sep 2022 02:50:17 GMT

A. B
Id1 amt1 Id2 amt2

1 1000 1 100
1 2000 1 200
1 3000. 2 300
2 4000. 2 400
2 5000. 2 500

What will be the various types of output if we merge ID1(a) and ID2 (b)

Re: What will be the various types of output if we merge ID1(a) and ID2 (b)

Kurt_Bremser — Sat, 17 Sep 2022 04:19:32 GMT

Please provide details instead of just posting the same question again, so one of us has to merge the threads.