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 are validation tools that are used in sas? : Sas-administrator
What is a macro routine?
If you could design your ideal job, what would it look like?
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
In proc transpose and data step with arrays which one you pick?
Of all your work, where have you been the most successful?
explain the key concept of sas? : Sas-administrator
What Proc glm does?
What was the last computer book you purchased? Why?
If money were no object, what would you like to do?
Difference between sum function and using “+” operator?
How substr function works in sas?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
what is slowly changing dimension? : Sas-di
what are informats in sas? : Sas-administrator
