Interested to Buy Any Domain ? << Click Here >> for more details...
describe about joins? briefly?
- 2 Answers
- 7061 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
we can use the set and merge commands to join the datas,use
merge if u like to joining data tables that has similar
observation and diff observation and relatted variable mean
use SET ,V can also use proc sql joing the data tables ,i am
beginner on sas so if any one have differ with my ans just
post to my mail kumarravi111@gmail.com
| Is This Answer Correct ? | 3 Yes | 1 No |
What are the default statistics for means procedure?
Explain substr function?
Are you involved in writing the inferential analysis plan? Tables specifications?
What are the special input delimiters used in SAS?
What is a pdv and what are its functions?
How do you add a number to a macro variable? : sas-macro
Explain what is the use of proc gplot?
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
what is ae onset date n what is RDS
what are the types of interactive display types? : Sas-bi
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
what is fact table and factless table?
Teradata 
