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
How to create an external dataset with sas code?
In ARRAY processing, what does the DIM function do?
do you prefer proc report or proc tabulate? Why? : Sas programming
What are the default statistics for means procedure?
Explain what is SAS informats?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
How can you create a macro variable with in data step? : sas-macro
Intern stastical programmer written test
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
how do the in= variables improve the capability of a merge? : Sas programming
what is study design in while working with SAS? what are screening variables in SAS?
In sas, what are the areas that you are most interested in? : sas-grid-administration
For clinical entire study how many tables will create approx?
Give e an example of..
describe about physical data integration? : Sas-di