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 -
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.