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
Mention sas system options to debug sas macros.
what do the pad and dim functions do? : Sas programming
Name some categories in sas 9? : sas-grid-administration
what techniques and/or procs do you use for tables? : Sas programming
Which command is used to perform sorting in sas program?
If a variable contains only numbers, can it be a character data type?
How to test the debugging in sas?
How do you delete duplicate observations in sas?
Explain by-group processing?
explain about various caches available in data integrator? : Sas-di
how do you want missing values handled? : Sas programming
Describe the ways in which you can create a macro variable?
which date function advances a date, time or datetime value by a given interval? : Sas programming
Give some ways by which you can define the variables to produce the summary report (using proc report)?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?