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

Answer Posted / pnprasad

There is no such Inner & Left Joins. In SAS only one join
i.e Right Join. If you want Left Join you have to use the
data set in the second place. For example: D1 D2 are the
data sets for D2 you want to make, UPDATE D1 D2;

Is This Answer Correct ?    1 Yes 22 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is proc sort?

719


Tell me about % include and % eval? : sas-macro

678


What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

583


what is sas metadata repository? : Sas-bi

602


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

653






what are sas/access and sas/connect? : Sas programming

548


what is study design in while working with SAS? what are screening variables in SAS?

1681


How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

1884


what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

547


State the difference between INFORMAT and FORMAT ?

599


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

645


why a stop statement is needed for the point= option on a set statement?

625


explain the difference between proc means and proc summary?

672


What is factor analysis?

662


What are the prime responsibilities of data integration administrator? : Sas-di

589