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
how could you generate test data with no input data? : Sas programming
Explain substr function?
what are some differences between proc summary and proc means? : Sas programming
explain what is factor analysis? : Sas-administrator
How would you determine the number of missing or nonmissing values in computations?
Tell e how how dealt with..
what are input dataset and output dataset options? : Sas programming
Explain the use of proc gplot? : sas-grid-administration
What system options would you use to help debug a macro? : sas-macro
What is the difference between class statement and by statement in proc means?
how the sas basic syntax style described? : Sas-administrator
Explain how merging helps to combine data sets.
If money were no object, what would you like to do?
Are you involved in writing the inferential analysis plan? Tables specfications?
How you can read the variables that you need?
