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

Mention sas system options to debug sas macros.

657


what do the pad and dim functions do? : Sas programming

560


Name some categories in sas 9? : sas-grid-administration

551


what techniques and/or procs do you use for tables? : Sas programming

569


Which command is used to perform sorting in sas program?

592






If a variable contains only numbers, can it be a character data type?

609


How to test the debugging in sas?

601


How do you delete duplicate observations in sas?

570


Explain by-group processing?

587


explain about various caches available in data integrator? : Sas-di

576


how do you want missing values handled? : Sas programming

530


Describe the ways in which you can create a macro variable?

618


which date function advances a date, time or datetime value by a given interval? : Sas programming

587


Give some ways by which you can define the variables to produce the summary report (using proc report)?

593


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1220