how to write code for left outer join in SAs using datastep?
- 8 Answers
- 20360 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
Explain the use of proc print and proc contents?
Give some ways by which you can define the variables to produce the summary report (using proc report)?
How sas treats the dsd delimiters?
What does the RUN statement do?
What are symget and symput? : sas-macro
What is factor analysis?
Explain the special input delimiters used in sas programming.
What is the purpose of _character_ and _numeric_?
What is PDV?
What are the limitations for memory allocation for SAS variables
What is SAS? What are the functions does it performs?
what is metadata? : Sas-bi
name some data transformation used in sas di? : Sas-di
What are the advantages of using sas?
What do you know about symput and symget?
