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
Do you need to know if there are any missing values?
why a stop statement is needed for the point= option on a set statement?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What system options would you use to help debug a macro? : sas-macro
what techniques and/or procs do you use for tables? : Sas programming
Given an unsorted data set, how to read the last observation to a new data set?
Are you involved in writing the inferential analysis plan? Tables specfications?
What is maximum number of rows and cols can be handled in SAS?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
what is snowflake schema? : Sas-di
Mention the difference between ceil and floor functions in sas?
what is business intelligence? : Sas-bi
What areas of SAS are you most interested in?
What does the trace option do?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana