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

Describe 5 ways to do a “table lookup” in SAS?

707


How do you connect the desktop application to metadata server? : sas-grid-administration

590


What are the different servers in sas? : sas-grid-administration

605


What are the default statistics for means procedure?

650


What are the different versions of sas that you have used until now? : sas-grid-administration

739






what are the considerations when picking a SAS/STAT procedure?

2907


What do the PUT and INPUT functions do?

787


What can you learn from the SAS log when debugging?

922


In SAS explain which statement does not perform automatic conversions in comparisons?

803


What system options would you use to help debug a macro? : sas-macro

646


How will you generate test data with no input data?

567


In sas admin differentiate between roles and capabilities? : sas-grid-administration

564


How to test the debugging in sas?

614


Did you used proc test? when?

1577


What are the ways to do a “table lookup” in sas?

595