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


Please Help Members By Posting Answers For Below Questions

why a stop statement is needed for the point= option on a set statement?

632


Mention some common errors that are usually committed in sas programming.

594


How you can read the variables that you need?

658


Explain why double trailing @@ is used in input statement?

579


What is the difference between INPUT and INFILE ?

760






What is the difference between nodupkey and nodup options?

599


Difference between sum function and using “+” operator?

608


explain what is factor analysis? : Sas-administrator

607


What are the data types does SAS contain?

659


In ARRAY processing, what does the DIM function do?

715


how would you create multiple observations from a single observation? : Sas programming

572


What is the function of Stop statement in a SAS Program?

650


Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1358


how will you locate the sas platform applications? : Sas-bi

586


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

739