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

I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,

What is the function of output statement in a SAS Program?

0 Answers  

what are the scrubbing procedures in sas? : Sas programming

0 Answers  

i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?

1 Answers   GSK,

what is the difference between SET and MERGE?

19 Answers   CitiGroup,

Which command is used to save logs in the external file?

0 Answers  

data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above code how to convert character data values to numeric data values?

3 Answers  

How we can call macros with in data step? : sas-macro

0 Answers  

Differentiate between format and informat? : sas-grid-administration

0 Answers  

What are the different operating system platforms in which we can use sas? : sas-grid-administration

0 Answers  

Can you suggest us materials for sdtm mapping?

0 Answers   TCS,

What is instream data in SAS?

1 Answers