i need help for MERGING two data sets with common data from both datasets.
Thanks in advance....
Asheesh
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):
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
- Cheers -
thanks for your answer..
but i need without proc SQL..
Regards, Asheesh
can u please help me with MERGE statement.
http://www.lexjansen.com/nesug/nesug11/ds/ds03.pdf
https://www.youtube.com/watch?v=zlDMwF3kQ6s
- Cheers -
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
Hi
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
...and remember btw that merge is not able to proceed a many-to-many relationship
Cheers
- Cheers -
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.