how can u join the two tables without using proc sql Joins
and nested queries ?
- 6 Answers
- 11368 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 |
How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...
in ods is there any lib's
how can you create zero observation dataset? : Sas programming
What do the PUT and INPUT functions do?
Enlist the functions performed by sas.
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
how do you test for missing values? : Sas programming
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.
Explain substr function?
Describe a time when you were really stuck on a problem and how you solved it?
describe the interaction table in sas di? : Sas-di
Explain append procedure?
Teradata 
