how can u join the two tables without using proc sql Joins
and nested queries ?
- 6 Answers
- 10864 Views
- IBM, I also Faced
- E-Mail Answers
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 |
name some data transformation used in sas di? : Sas-di
what is the difference between %put and symbolgen?
What is run-group processing?
Do you prefer Proc Report or Proc Tabulate? Why?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
What does error:1 mean?
Briefly describe 5 ways to do a "table lookup" in sas.
1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.
Do you need to know if there are any missing values?
Why is a STOP statement needed for the point=option on a SET statement?
I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?
what are the component of range? : Sas-bi
Teradata 
