Data left_outer; merge emp(in=a) dept(in=b); by deptno; if a=1 and b=0;

how to write code for left outer join in SAs using datastep?

Question Posted / aniruddha

Answer Posted / aniruddha

Data left_outer;
merge emp(in=a) dept(in=b);
by deptno;
if a=1 and b=0;
run;

Is This Answer Correct ?

22 Yes

8 No

Please Help Members By Posting Answers For Below Questions

In sas, what are the areas that you are most interested in? : sas-grid-administration

1017

what is program data vector? : Sas-administrator

1008

how does sas handle missing values in assignment statements? : Sas programming

963

For what purposes have you used sas macros? : sas-macro

949

How to limit decimal places for the variable using proc means?

995

Which command is used to save logs in the external file?

1024

how many types prompting framework can be broken down to? : Sas-bi

1029

how would you create multiple observations from a single observation? : Sas programming

949

Do you need to know if there are any missing values?

993

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4419

what is hash files in sas and why we are using this one in sas?

2153

what is sas metadata repository? : Sas-bi

1049

what is enterprise guide? What is the use of it? : Sas programming

947

Give an example where SAS fails to convert character value to numeric value automatically?

1024

How long can a macro variable be? A token? : sas-macro

1152