Interested to Buy Any Domain ? << Click Here >> for more details...
describe about joins? briefly?
- 2 Answers
- 7211 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 has been your most common programming mistake? : Sas programming
what is intially documentation in sas?
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
: and & modifiers.
WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS FUNCTION?
How can you put a "trace" in your program?
Approximately what date is represented by SAS date value of 730
How many data types are there in SAS?
What are the new features included in the new version of SAS Programming Language?
What is the SAS data set?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
it will become easy if uuu provide website linkssss and list of consultanciessssss
Teradata 
