Interested to Buy Any Domain ? << Click Here >> for more details...
how to write code for left outer join in SAs using datastep?
- 8 Answers
- 21554 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answer Posted / uma
first sort these datasets by common variable DEPT_ID,Then
use the following:
data left_join;
merge emp (in=a) dept (in=b);
by dept_id;
if a then output;
run;
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
What is data _null_?
explain what is data set in sas? : Sas-administrator
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
what is operational data and operational system? : Sas-di
What is a method to debug and test your SAS program?
what are sas bi dashboard components? : Sas-bi
AE datasets names? how many types?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
What is the use of PROC gplot?
Enlist the syntax rules followed in sas statements.
how many types prompting framework can be broken down to? : Sas-bi
What is the difference between INPUT and INFILE ?
What is the purpose of trailing @ and @@? How do you use them?
What do you understand by the term Normal Distribution?
