how can u join the two tables without using proc sql Joins
and nested queries ?
Answers were Sorted based on User's Feedback
Answer / kumarravi111
we can use Merge and set statements to join the tables in
Data step
| Is This Answer Correct ? | 19 Yes | 1 No |
Answer / sai
we can join two tables by using merge statement and also by
using two SET statements .
data one;
set two;
set three;
run;
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vimal
actually i think UNION and UNION ALL is the correct answer.. since they ask related to that.
| Is This Answer Correct ? | 1 Yes | 2 No |
What is the command used to find missing values?
What are the joins,types of joins and thier functions?
What is the difference between SAS Data step and SAS PROC SQL, and which is better?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
Why double trailing @@ is used in input statement?
Explain why double trailing @@ is used in input statement?
in data set200 observation how to take 110,150,170 using sql procedure?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?
What report output formats can you generate using SAS?
what is sas enterprise intelligence architecture? : Sas-bi
List down the reasons for choosing sas over other data analytics tools.
WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.