describe about joins? briefly?
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 |
I need level 2 to 5 sas using companies in india
Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190
how to generate report for 0 observation dataset?
How to convert a given date value into SAS date
9 Answers CitiGroup, Quintiles,
Tell e how how dealt with..
what is business intelligence? : Sas-bi
how many types of MERGE?
how to remove duplicates using proc sql?
if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually
Explain how merging helps to combine data sets.
what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.
How would you code a merge that will keep only the observations that have matches from both sets.
5 Answers Accenture, Bank Of America,