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 -
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.