how to write code for left outer join in SAs using datastep?
Answer Posted / lakshmi
data left_join;
merge data1(in=a) data2(in=b);
by subjid;
if a;
run;
Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
What is the role of administrative users? : sas-grid-administration
How would you define the end of a macro? : sas-macro
Name any two sas spawners? : sas-grid-administration
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
what is star schema? : Sas-di
what is the Population you used in your project, is it ITT or PP?
What are the advantages of using sas?
Mention what is PROC in SAS?
how does sas handle missing values in assignment statements? : Sas programming
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
what is factor analysis? : Sas-administrator
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
What is the difference between reading data from an external file and reading data from an existing data set?
What do you understand by the term Normal Distribution?