topic Re: Merge and what is output? in SAS Programming

Merge and what is output?

GN0001 — Sun, 26 Feb 2023 20:07:30 GMT

merge old(in=a) trap(in=b);
 by this that;
 if a and not b then check='Only l';
 if b and not a then check='Only n';
 if a and b then check='Match';
 if a or b  then output;
run;

Hello team,

Will "if a or b then output" be back in the result only? Please advise.

Respectfully,

blueinthesky

Re: Merge and what is output?

Kurt_Bremser — Sun, 26 Feb 2023 20:12:25 GMT

Ask yourself:"what does the OUTPUT statement do?"

You'll have your answer.

And then ask yourself if the statement is necessary at all. Can there ever be a case where neither a nor b is true?

Re: Merge and what is output?

PaigeMiller — Sun, 26 Feb 2023 23:05:14 GMT

@GN0001 wrote:
merge old(in=a) trap(in=b);
 by this that;
 if a and not b then check='Only l';
 if b and not a then check='Only n';
 if a and b then check='Match';
 if a or b  then output;
run;
Hello team,

Will "if a or b then output" be back in the result only? Please advise.

Respectfully,

blueinthesky

This is the exact type of problem you should try yourself, and see what happens. If you take SASHELP.CLASS and remove a few rows and create data set A, then take SASHELP.CLASS and remove other rows and create data set B, then merge by NAME, you will see what happens.

Re: Merge and what is output?

GN0001 — Mon, 27 Feb 2023 03:48:02 GMT

Thanks for response. Why do you mean remove? Do you mean to create a subset?
Thanks one more time.
Blue blue

Re: Merge and what is output?

GN0001 — Mon, 27 Feb 2023 03:50:08 GMT

Can you please explain a little bit more?
Thanks
Blue

Re: Merge and what is output?

Kurt_Bremser — Mon, 27 Feb 2023 05:54:59 GMT

I gave you two questions. Answer them.

Re: Merge and what is output?

GN0001 — Mon, 27 Feb 2023 06:15:17 GMT

Hello Kurt,

That is what I try to say. The last statement is not needed at all. I did what paigemiller suggested, All the cases of two tables are discussed earlier, so, that last statement is not needed, and it is not correct at all. I kind of knew that before I posted my question, I wanted to make sure.

Thanks,

Blue

Re: Merge and what is output?

Kurt_Bremser — Mon, 27 Feb 2023 10:34:51 GMT

@GN0001 wrote:

Hello Kurt,

That is what I try to say. The last statement is not needed at all. I did what paigemiller suggested, All the cases of two tables are discussed earlier, so, that last statement is not needed, and it is not correct at all. I kind of knew that before I posted my question, I wanted to make sure.

Thanks,

Blue

This is where I wanted to lead you. If your question had been "I do not think that the last IF statement is needed. Is this correct?" my answer would simply have been "Yes, you are right".

Re: Merge and what is output?

PaigeMiller — Mon, 27 Feb 2023 11:20:00 GMT

@GN0001 wrote:
Thanks for response. Why do you mean remove? Do you mean to create a subset?
Thanks one more time.
Blue blue

SASHELP.CLASS has 19 rows. If you remove some rows, the new data set has fewer than 19.