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

Name and describe few sas character functions that are used for data cleaning in brief.

1058

What are the table names in oracle database...?

2690

Explain what is SAS informats?

1042

explain about data integrator metadata reports? : Sas-di

1040

What does P-value signify about the statistical data?

1305

Mention common programming errors committed in sas ?

1064

what is null hypothesis? why do you consider that?

2849

what can you learn from the sas log when debugging? : Sas programming

1028

what is the difference between nodup and nodupkey options? : Sas programming

1114

why is sas considered self-documenting? : Sas programming

1083

What are types of transport files?

7867

do you need to know if there are any missing values? : Sas programming

990

What commands are used in the case of including or excluding any specific variables in the data set?

1021

In proc transpose and data step with arrays which one you pick?

3044

Have you used macros? For what purpose you have used? : sas-macro

992