Interested to Buy Any Domain ? << Click Here >> for more details...
describe about joins? briefly?
- 2 Answers
- 7313 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 |
Can we use where and having clauses in a single SAS program. ex: proc sql; select a,b,c from test where state in 'KA' and having <some condition>. Is the above program run correctly, if not why ?
what can you learn from the sas log when debugging? : Sas programming
what is the prob plot in clinical domain
Diff between proc sql merge and join?
What is the difference between informat and format statement?
Tell different ways to create Macrovarible?
3 Answers Accenture, PharmaNet i3,
What makes sas stand out to be the best over other data analytics tools?
Explain the difference between using drop = data set option in set and data statement?
what is TAB delimiter? explain about it? what will you do to get TAB delimiter?
How to save the log information in a file for future use
Hi All.I am looking for Good Institute who could Provide the online SAS BI+DI Training along with software.Primarily in Delhi/NCR or in Hyderabad Please help with name and contact number of concerned person!! Thanks in Advance! :)
how does sas handle missing values in sort order? : Sas programming
Teradata 
