Answer / tangyoulei

data new1 new2 new3;
merge old1 (in=one) old2 (in=two);
if one and two then output new1;
else if one and not two then output new2;
else output new3;
run;

Answer / arun & g.n.rao

data one;
input ID$ NAME$;
datalines;
A01 SUE
A02 TOM
A05 KAY
A10 JIM
;
RUN;
DATA TWO;
INPUT ID$ AGE SEX$;
DATALINES;
A01 58 F
A02 20 M
A04 47 F
A10 11 M
;
RUN;

DATA N1 N2 N3;
MERGE ONE (IN=X) TWO (IN=Y);
BY ID;
IF X=1 AND Y=1 THEN OUTPUT N1;
IF X=1 AND Y=0 THEN OUTPUT N2;
IF X=0 AND Y=1 THEN OUTPUT N3;
RUN;

Answer / 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;

Answer / vinod swarna

proc sql;

create table both_match as
select *
from one
intersect
select *
from two;

create table left_non as
select *
from one
except
select *
from two;

create table right_non as
select *
from two
except
select *
from one;

quit;

Answer / lakshmi

data data1 data2 data3;
merge left(in-a) right(in=b);
by subjid;
if a and b then output data1;
if a and not b then output data2;
if b and not a then output data3;
run;

Answer / vipin choudhary

Assume the common variable in both of the old datasets
is "name".
Data One two three;
merge old(in = in1) old1(in = in2);
by name;
if in1 and in2 then output one;
if in1 then output two;
if in1 = 0 and in2 = 1 then output three;
run

Answer / giri

this problem over come by using the joins statements

Answer / vinod

what is the error u r getting ?

Answer / m.sivakumar

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 coalesce(one.id,two.id)as
id,name,age,sex from one right join two on one.id=two.id
where one.id is null;

quit;

Answer / padma

The above proc sql is not working. it is throwing up error.

Please verify. If anybody give proc sql code for the above
question that would be great.

padma

Enlist the syntax rules followed in sas statements.

0 Answers  

If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

1 Answers  

what is Difference between PROC SQL JOINS and MERGE?

3 Answers   Accenture, Wipro,

Difference between informat and format?

0 Answers  

I need level 2 to 5 sas using companies in india

0 Answers  

how to rearrange the data as our wish by using dataset block?

4 Answers   Cognizant,

What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;

3 Answers  

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 Answers  

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

0 Answers  

what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?

3 Answers  

WHAT DOES A SAS SPECIFICATION DOCUMENT SDS CONTAIN ?

1 Answers  

What are the rows present in protocol Violation table?

2 Answers   Accenture, Quintiles,