Interested to Buy Any Domain ? << Click Here >> for more details...
how can u join the two tables without using proc sql Joins
and nested queries ?
- 6 Answers
- 13275 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 |
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
Explain the difference between nodup and nodupkey options?
How substr function works in sas?
for whom is sas data integration studio designed? : Sas-di
How to find out no. of business days in a month using macros.???(excluding weekends and holidays).
How can you create a macro variable with in data step? : sas-macro
Explain what Proc glm does?
What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here
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's the difference between VAR A1 - A4 and VAR A1 - A4?
What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?
Teradata 
