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’s the difference between var b1 – b3 and var b1 — b3?

1300

what are _numeric_ and _character_ and what do they do? : Sas programming

1122

Difference between sum function and using “+” operator?

1104

How to limit decimal places for variable using proc means?

1062

Explain bmdp procedure?

998

What are the uses of sas?

1195

Difference between SAS STATA & SPSS?

1079

Explain what is data step?

1161

What is the difference between match merge and one to one merge?

1180

What is the difference between SAS functions and procedures?

1113

How do you control the number of observations and/or variables read or written?

1209

What are the data types that sas contain?

1134

What is the difference between order and group variable in proc report?

1390

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1436

What does P-value signify about the statistical data?

1328