how to write code for left outer join in SAs using datastep?
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 change analysis in sas di ? : Sas-di
What is the basic structure of a sas program?
How substr function works in sas?
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
Name any two sas spawners? : sas-grid-administration
What is the purpose of trailing @ and @@? How do you use them?
How to create an external dataset with sas code?
What commands are used in the case of including or excluding any specific variables in the data set?
What can be the size of largest dataset in SAS?
what is SAS OPTIMIZATION?
what is ae onset date n what is RDS
What are the different servers in sas? : sas-grid-administration
What are the difficulties u faced while doing vital signs table or dataset?
how are numeric and character missing values represented internally? : Sas programming
Where do you use proc means over proc freq?