how can u join the two tables without using proc sql Joins
and nested queries ?
- 6 Answers
- 11906 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 |
What are the default statistics for means procedure?
What are the five ways to do a table lookup in sas? : sas-grid-administration
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
How does the internal authentication work in sas? : sas-grid-administration
why is sas data integration studio important? : Sas-di
data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.
Name the option to produce a frequency line items rather that a table.
I have a dataset concat having variable a b & c. How to rename a b to e & f?
what does .. meant in sas macros
what is function of retain statment
What is the difference between reading data from an external file and reading data from an existing data set?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
Teradata 
