topic Re: please help in inner join in SAS Programming

please help in inner join

asheeshdhupper7 — Wed, 19 Apr 2017 08:16:50 GMT

i need help for MERGING two data sets with common data from both datasets.

Thanks in advance....

Asheesh

Re: please help in inner join

RW9 — Wed, 19 Apr 2017 08:21:50 GMT

Do the video training or a course? If you have a specific question, then please start by formulating test data, in the form of a datastep which will illustrate what you are working with (just a few rows), then show the ouput you require, and provide any code you may already have tried (use the {i} above your post for code blocks). All I can provide without any information is my usual graphic on joins (which can also be done just as well in datastep merge but I don't have the graphic for that):

Re: please help in inner join

Oligolas — Wed, 19 Apr 2017 08:31:43 GMT

Hi,

Choose the join you need from the graphic below.

If you still need help consult

http://www.listendata.com/2014/04/proc-sql-select-statement.html

https://www.youtube.com/watch?v=rF5DC3CPORc

https://www.youtube.com/watch?v=rIbdmdVdAgQ

or post a specific question with sample data.

Cheers

Re: please help in inner join

asheeshdhupper7 — Wed, 19 Apr 2017 08:26:35 GMT

thanks for your answer..

but i need without proc SQL..

Regards, Asheesh

Re: please help in inner join

asheeshdhupper7 — Wed, 19 Apr 2017 08:28:04 GMT

can u please help me with MERGE statement.

Re: please help in inner join

Oligolas — Wed, 19 Apr 2017 08:35:16 GMT

http://www.lexjansen.com/nesug/nesug11/ds/ds03.pdf

https://www.youtube.com/watch?v=zlDMwF3kQ6s

Re: please help in inner join

RW9 — Wed, 19 Apr 2017 08:41:32 GMT

If your not going to provide any information then you wont get a useful answer. Refer to the manual:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000202970.htm

Re: please help in inner join

BrunoMueller — Wed, 19 Apr 2017 08:42:28 GMT

I would take the free e-Learning SAS Programming 1: Essentials so you can learn all the basics about SAS programming. Lesson 10 will give information about different ways to combine tables.

Bruno

Re: please help in inner join

silvergrenade — Wed, 19 Apr 2017 09:02:42 GMT

Hi Asheesh,
Use the following snippet to find a data merge in data step.

data test;
merge X(in=a) Y (in=b) Z (in=c);
by common_variable;
mi_ind=compress(a||b||c);
run;

The mi_ind would help you in determining from where the particular row is coming from

Re: please help in inner join

Oligolas — Wed, 19 Apr 2017 13:33:01 GMT

...and remember btw that merge is not able to proceed a many-to-many relationship

Cheers