describe about joins? briefly?
- 2 Answers
- 6162 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 is the difference between infile and input? : Sas-administrator
what is the SAS/ACCESS and SAS/CONNECT?
9 Answers Accenture, iFlex, TCS,
How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO
What is the role of unrestrictive users? : sas-grid-administration
Explain how merging helps to combine data sets.
For what purpose(s) would use the RETURN statement?
how to read raw data in sas. Do it manually and throw the programming.
how many types of prompts are there? : Sas-bi
What are symget and symput? : sas-macro
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
How many versions came upto now in SAS?
WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?
Teradata 
