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

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1132

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

1012

What is the sas data set? : sas-grid-administration

976

Differences between where and if statement?

1077

describe how to adjust the performance of data integrator? : Sas-di

1001

What is the role of administrative users? : sas-grid-administration

1072

how are numeric and character missing values represented internally? : Sas programming

1136

What are the scrubbing procedures in sas?

1000

What are the default statistics that proc means produce?

1032

What system options would you use to help debug a macro? : sas-macro

1088

What is the work of tranwrd function?

1237

How would you identify a macro variable? : sas-macro

1014

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

1265

it will become easy if uuu provide website linkssss and list of consultanciessssss

1969

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1277