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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does PROC print, and PROC contents do?

730


Compare sas with other data analytics tools.

583


what are validation tools that are used in sas? : Sas-administrator

593


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

540


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

625






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

802


how does sas handle missing values in sort order? : Sas programming

534


Tell e how how dealt with..

1771


Given an unsorted data set, how to read the last observation to a new data set?

837


What is proc sort?

719


what is sas data set?

669


Define run-group processing?

581


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

1914


What do you know about sas data set?

594


Name any two sas spawners? : sas-grid-administration

560