topic Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B in SAS Programming

I AM NOT ABLE TO EXECUTE MERGE BETWEEN TWO DATA SETS. SAS IS NOT ABLE TO DETECT DATA SET A AND B IN

Shailesh_R_T — Sun, 11 May 2025 17:19:45 GMT

DATA A;
INPUT id name$ Height;
datalines;
1 A 1
3 B 1
5 C 2
7 D 2
9 E 2
;
run;
DATA B;
INPUT id name$ weight;
datalines;
2 A 2
4 B 3
5 C 4
7 D 5
;
run;
;
proc sort data=A;
by ID;
run;
;
proc sort data=B;
by ID;
run;

DATA xyz;
MERGE A B;
BY ID;
RUN;

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

PaigeMiller — Sun, 11 May 2025 17:38:48 GMT

Please do not type in ALL CAPITAL LETTERS.

When you get errors in the log, then please show us the entire log. In fact, please do that for this problem and all future problems. Do not paraphrase error messages.

When I run your code, I get no errors at all.

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Cynthia_sas — Sun, 11 May 2025 18:06:41 GMT

Hi:

I agree, when I run the original code, I do not have any errors in the SAS log. However, the issue might be that the output is not what was expected or desired. Here's the output I get when I do a PROC PRINT on the the original work.xyz data after the merge:

Here's the log from the original code:

However, I think that this might be a case where using IN= option for the merge might be useful. Also, in this case, with the original code, it appears that there might be issues, unexpected results for ID=1, NAME=A and ID=2, NAME=A and the same with NAME=B.

So if you change the code a bit so that there are 2 different variables, NAMEA in dataset A and NAMEB in dataset B, then this code can be run as a test:

DATA A;
INPUT id nameA $ Height;
datalines;
1 A 1
3 B 1
5 C 2
7 D 2
9 E 2
;
run;
  
DATA B;
INPUT id nameB $ weight;
datalines;
2 A 2
4 B 3
5 C 4
7 D 5
;
run;
 
proc sort data=A;
by ID;
run;
 
proc sort data=B;
by ID;
run;

DATA xyz A_only B_only BOTH ;
MERGE A(in=froma) B(in=fromb);
BY ID;
output xyz;
** now test merge in more depth by testing in= option values;
** and outputting observations to different output data tables;
if froma = 1 and fromb = 1 then output both;
else if froma=1 and fromb = 0 then output A_only;
else if froma=0 and fromb = 1 then output B_only;
RUN;

proc print data=xyz;
  title '1) XYZ data table';
run;

proc print data=A_only;
title '2) A_only data table';
run;

proc print data=B_only;
title '3) B_only data table';
run;

proc print data=both;
title '4) Both data table';
run;
title;

Then this is what is in the log:

And the PROC PRINT output:

I'm not clear on whether the original code posted has a logic program or a data problem. But using IN= might help clarify the solution.

Cynthia

Re: I AM NOT ABLE TO EXECUTE MERGE BETWEEN TWO DATA SETS. SAS IS NOT ABLE TO DETECT DATA SET A AND B

Tom — Sun, 11 May 2025 18:47:56 GMT

You seem to have two different KEY variables. Which one is the important one? ID or NAME?

Merging by NAME leads to a different result

than merging by ID.

Re: I AM NOT ABLE TO EXECUTE MERGE BETWEEN TWO DATA SETS. SAS IS NOT ABLE TO DETECT DATA SET A AND B

Amir — Sun, 11 May 2025 21:51:44 GMT

Hi,

I'm not sure if your subject line has been truncated; was there more to it?

Please provide a data step with datalines to show what output data set you are expecting, along with a brief explanation of the logic rules that generate your output.

Thanks & kind regards,

Amir.

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

PaigeMiller — Mon, 12 May 2025 11:45:06 GMT

I think we need to hear from @Shailesh_R_T about what the problem is, in much more detail. Everyone guessing different things isn't really a good approach.

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Shailesh_R_T — Mon, 12 May 2025 16:42:47 GMT

Hey @PaigeMiller i am beginner, currently learning SAS basics. Even i don't have solution for this, i tried with proc print it worked out but still don't know if its the right way, if anyone came across solution for this please approach or discuss. Can anyone help me with mock tests or daily quiz for practice purpose for base sas examination

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

PaigeMiller — Mon, 12 May 2025 16:44:19 GMT

@Shailesh_R_T wrote:

Hey @PaigeMiller i am beginner, currently learning SAS basics. Even i don't have solution for this, i tried with proc print it worked out but still don't know if its the right way, if anyone came across solution for this please approach or discuss

I asked to see the log. If there are errors in the log, SHOW US the log! Even if you are a beginner, you can explain better and provide us with more information (which we have specifically requested).

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Shailesh_R_T — Mon, 12 May 2025 16:49:40 GMT

please have a look a discuss

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

PaigeMiller — Mon, 12 May 2025 16:55:22 GMT

Many people here refuse to download file attachments.

Please paste whatever text you want us to see into your reply.

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Amir — Mon, 12 May 2025 17:00:58 GMT

Hi,

Part of the subject says "I am unable to execute merge...", but the log shows the merge has been executed.

Another part of the subject says "SAS is not able to detect data set A and B...", but the log shows data set A and B were detected when they were used in the merge.

Are you happy with the results of the final data set? If yes, then what is your question? If no, then what result did you expect to get instead - please supply a data step with datalines showing the output you expect.

Thanks & kind regards,

Amir.

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Shailesh_R_T — Mon, 12 May 2025 17:02:37 GMT

might be you are right

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Cynthia_sas — Mon, 12 May 2025 20:58:57 GMT

Hi:

As several members have pointed out, your original code runs without error. Therefore, you either have a data problem or a program logic problem. Without more definition from you about exactly why you think your merge is not working, with examples, and what you would consider to be the correct results, with examples, it is nearly impossible to provide constructive suggestions. Several of us have posted information about how your original code is working without errors. There have also been repeated guesses about whether your using the correct variables in the merge or whether you need to merge by both ID and NAME or whether there is something wrong with your data. However, without some further clarification from you, it is hard to help.

Cynthia

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Shailesh_R_T — Thu, 15 May 2025 14:12:12 GMT

i am not happy with the results. data set A and B has not merged in output window despite showing no error in log. As per my knowledge the code is also right. I have attached code and log window for your referance

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Shailesh_R_T — Thu, 15 May 2025 14:14:12 GMT

here is code and log window for your reference.

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Amir — Thu, 15 May 2025 14:19:57 GMT

Hi,

Please share the result that you have and also show us the result that you want (using a data step with datalines) so that we can see what the difference is between the result that you have and the result that you want.

Please also tell us some rows that you think are incorrect and why.

Thanks & kind regards,

Amir.

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Shailesh_R_T — Thu, 15 May 2025 14:25:00 GMT

I got the expected result using proc print syntax at the end

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Amir — Thu, 15 May 2025 14:32:44 GMT

Hi,

Just to make sure, are you saying using you have a solution now (using proc print)?

Thanks & kind regards,

Amir.

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

PaigeMiller — Thu, 15 May 2025 14:34:25 GMT

Paste the text of the code and text of the log directly into your reply. Do not include it as an attachment.

And since we have asked many times, I ask one more time ... please EXPLAIN what is wrong with the results.

Re: I am not able to execute merge between two data sets. SAS is not able to detect data set A and B

Tom — Thu, 15 May 2025 14:38:01 GMT

So the actual question was how to look at the dataset created by the data step with the merge statement?

PS Please try to avoid attaching files. When sharing code and log please share as text and use the Insert SAS Code or Insert Code buttons in the icon bar of the forum editor. The same for data listings if you can (ODS output does make that almost impossible). If you must share an image insert the image using the Insert Photos icon (or just paste it in).