proc sql; select * from one left join two on one.X=two.X; quit;

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

Question Posted / raghava

Answer Posted / raghava

proc sql;
select *
from one left join two
on one.X=two.X;
quit;

The above is code for lefjoin.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the data types that sas contain?

1185

What is the function of Stop statement in a SAS Program?

1152

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

1019

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2413

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1538

How do you define proc in sas? : sas-grid-administration

1085

how could you generate test data with no input data? : Sas programming

1188

what is the primary data source for the wrs? : Sas-bi

1237

Can you execute macro within another macro? : sas-macro

996

Explain the special input delimiters used in sas programming.

1008

what are the benefits of data integration? : Sas-di

1108

Enlist the syntax rules followed in sas statements.

1086

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1620

List out some key concept of SAS

1125

What is the maximum length of the macro variable? : sas-macro

1094