how to write code for left outer join in SAs using datastep?

Answer Posted / venkatesh

if you use x=1 and y=0
you must use set statement also
try this
data a b;
merge one two;
by id;
if x=1 and y=1 then output a;
if x=1 and y=0 then output b;
data new;
set a b;
run;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you delete duplicate observations in sas?

577


Do you know the features of sas?

592


What is the differnce between SDTM 3.1.2 to 3.1.1 version

4609


Have you ever used the SAS Debugger?

1207


for what purpose would you use the retain statement? : Sas programming

585






explain the use of % includes a statement in sas? : Sas-administrator

549


AE datasets names? how many types?

2078


Name types of category in which SAS Informats are placed?

736


Explain what Proc glm does?

639


Explain translate function?

634


Explain bmdp procedure?

614


What is the difference between %local and %global? : sas-macro

668


How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

583


What are the different servers in sas? : sas-grid-administration

600


What commands are used in the case of including or excluding any specific variables in the data set?

594