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

What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.

1 Answers   Cipla,

---

Explain why double trailing @@ is used in input statement?

0 Answers  

---

define table lookup and how may ways it can be done...explian

3 Answers  

---

How would you identify a macro variable?

0 Answers  

---

what is portability of sas programmes?

2 Answers   Capital One,

---

Can you excute a macro within a macro? Describe.

2 Answers   Genta,

---

if we dont want to print output what we have to do..???give syntax..???

8 Answers   Accenture, GSK GlaxoSmithKline,

---

how to perform paired t-test using Base/SAS & SAS/Stat?

2 Answers  

---

What are the statements in proc sql?

0 Answers  

---

how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this?

8 Answers   Wipro, Xansa,

---

what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?

3 Answers  

---

how to import HTML files into SAS datasets?

3 Answers   HP,

---