how to write code for left outer join in SAs using datastep?
Answer Posted / aniruddha
Data left_outer;
merge emp(in=a) dept(in=b);
by deptno;
if a=1 and b=0;
run;
Is This Answer Correct ? | 22 Yes | 8 No |
Post New Answer View All Answers
How do you connect the desktop application to metadata server? : sas-grid-administration
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
what is the purpose of _error_? : Sas programming
What does the trace option do?
what is hierarchy flattening? : Sas-di
how do the in= variables improve the capability of a merge? : Sas programming
do you need to know if there are any missing values? : Sas programming
Define run-group processing?
What are the uses of sas?
how many types of prompts are there? : Sas-bi
What are the different versions of sas that you have used until now? : sas-grid-administration
What is the length assigned to the target variable by the scan function?
explain about data integrator metadata reports? : Sas-di
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di