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
Describe 5 ways to do a “table lookup” in SAS?
Why and when do you use proc sql?
do you prefer proc report or proc tabulate? Why? : Sas programming
What are the differences between sum function and using “+” operator?
How necessary is it to be creative in your work?
what can you learn from the sas log when debugging? : Sas programming
What function CATX syntax does?
Enlist the functions performed by sas.
Describe the function and utility of the most difficult SAS macro that you have written?
what is the primary data source for the wrs? : Sas-bi
Difference between nodup and nodupkey options?
Describe the function and untility of the most difficult SAS macro that you have written.
What does the RUN statement do?
what do you mean by data staging area? : Sas-di
what is PhaseIII, ODS, TLG, Macro and Proc in SAS