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
How do you define proc in sas? : sas-grid-administration
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
what is sas metadata repository? : Sas-bi
What is the sas data set? : sas-grid-administration
What is the difference between reading data from an external file and reading data from an existing data set?
Differentiate input and infile.
Give e an example of..
What is the use of divide function?
Name some categories in sas 9? : sas-grid-administration
Explain the difference between nodup and nodupkey options?
What is the basic structure of a sas program?
how to change the execute of macro
How do dates work in sas?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
What are the data types in sas?
