Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is the difference between nodupkey and nodup options?
Explain the main difference between the sas procedures and functions? : Sas-administrator
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
How can sas program be validated?
what is the difference between floor and ceil functions in sas? : Sas-administrator
how to generate the test data in sas without input data? : Sas-administrator
How do you control the number of observations and/or variables read or written?
What is the function of output statement in a SAS Program?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
How to limit decimal places for variable using proc means?
Describe the function and untility of the most difficult SAS macro that you have written.
What are the implications?
what is the Population you used in your project, is it ITT or PP?
how can you create zero observation dataset? : Sas programming
What Proc glm does?
