Interested to Buy Any Domain ? << Click Here >> for more details...
how to write code for left outer join in SAs using datastep?
- 8 Answers
- 21244 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
how does sas handle missing values in formats? : Sas programming
What is slibref?
name some data transformation used in sas di? : Sas-di
In ARRAY processing, what does the DIM function do?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
how do the in= variables improve the capability of a merge? : Sas programming
How to create a permanent sas data set?
Name some categories in sas 9? : sas-grid-administration
what is sas enterprise intelligence architecture? : Sas-bi
What are the implications?
How do dates work in sas?
Explain data_null_?
Have you used macros? For what purpose you have used? : sas-macro
What is the order of application for output data set options, input data set options and SAS statements?
how can you create zero observation dataset? : Sas programming
