Interested to Buy Any Domain ? << Click Here >> for more details...
How would you code a merge that will write the matches of
both to one data set, the non-matches from the left-most
data set to a second data set, and the non-matches of the
right-most data set to a third data set.
- 10 Answers
- 18542 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / proc sql
proc sql:
proc sql;
create table sqln1 as select one.id,name,age,sex from one
inner join two on one.id=two.id;
create table sqln2 as select one.id,name,age,sex from one
left join two on one.id=two.id where two.id is null;
create table sqln3 as select two.id,name,age,sex from one
right join two on one.id=two.id where one.id is null;
quit;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
what can you learn from the sas log when debugging? : Sas programming
In proc transpose and data step with arrays which one you pick?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
what do the pad and dim functions do? : Sas programming
How many data types are there in SAS?
What is the good sas programming practices for processing large data sets?
What are the difference between sas functions and procedures?
What is PDV?
What commands are used in the case of including or excluding any specific variables in the data set?
What is the difference between using drop = data set option in data statement and set statement?
What is the role of sas grid administrator? : sas-grid-administration
what is sas data set?
explain about sas business intelligence? : Sas-bi
