how to write code for left outer join in SAs using datastep?
- 8 Answers
- 20255 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answer Posted / uma
first sort these datasets by common variable DEPT_ID,Then
use the following:
data left_join;
merge emp (in=a) dept (in=b);
by dept_id;
if a then output;
run;
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
Describe the ways in which you can create macro variables?
Mention few capabilities of sas framework.
Explain substr function?
Briefly explain input and put function?
explain the concepts and capabilities of business object? : Sas-bi
what are _numeric_ and _character_ and what do they do? : Sas programming
What are the parameters of scan function?
describe the interaction table in sas di? : Sas-di
explain about sas business intelligence? : Sas-bi
In SAS explain which statement does not perform automatic conversions in comparisons?
How to create list output for cross-tabulations in proc freq?
what is sas olap server? : Sas-di
: and & modifiers.
What is the difference between reading data from an external file and reading data from an existing data set?
How would you include common or reuse to be processed along with your statements?
