Answer / hardeep malhotra

Use proc sql for joins,

There are 5 types of joins in sas

1) Inner Join :- Output would be only matched cases.

2) left outer Join :- Output would be all the rows from
left table with corresponding matched value from right
table.

3) right Join :- vice versa of left Join.

4) Full outer join :- will take all matched & unmatched
rows of both the tables.

5) Product Join :- this will join the 2 tables without any
common variable.

Answer / rrrrrrr

we can use the set and merge commands to join the datas,use
merge if u like to joining data tables that has similar
observation and diff observation and relatted variable mean
use SET ,V can also use proc sql joing the data tables ,i am
beginner on sas so if any one have differ with my ans just
post to my mail kumarravi111@gmail.com

How do you put a giraffe into the refrigerator?

3 Answers   Oracle,

---

What is univariate n where it can be used n how...?

2 Answers  

---

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

0 Answers  

---

Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?

2 Answers  

---

what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

0 Answers  

---

What is the basic syntax of a sas program?

0 Answers  

---

Which are SAS Windows Clients & SAS Java Clients

3 Answers   TCS,

---

how does sas handle missing values in sort order? : Sas programming

0 Answers  

---

what are input dataset and output dataset options? : Sas programming

0 Answers  

---

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

0 Answers  

---

what is portability of sas programmes?

2 Answers   Capital One,

---

Can anyone help me about SAS Realtime scenarios in Clinical field

0 Answers  

---