Merging Problem

[KatLinden]

Hi,

I have two datasets:

Dataset A:

ID  Gender

1     M

Dataset B:

Date

1/1/2010

1/2/2010

I'm trying to create a dataset that looks like this:

ID  Gender  Date

1     M          1/1/2010

1     M          1/2/2010

Is that possible?

[novinosrin]

data a;
input ID  Gender $;
cards;
1     M
;
data b;
input Date $10.;
cards;
1/1/2010
1/2/2010
;
data want;
if 0 then set a;
set b;
if _n_=1 then set a;
run;

[KatLinden · Accepted solution]

Thank you so much!  

[novinosrin]

@KatLinden Welcome to the SAS community forum. I hope you have a fun journey with us 🙂

[KatLinden]

Thank you!  One more question.  How does this work if I have several observations in dataset A?

I have two datasets:

Dataset A:

ID  Gender

1     M

2     F

.

.

.

etc

Dataset B:

Date

1/1/2010

1/2/2010

I'm trying to create a dataset that looks like this:

ID  Gender  Date

1     M          1/1/2010

1     M          1/2/2010

2     F           1/1/2010

2     F           1/2/2010

.

.

.

etc

[novinosrin]

I would request you to provide us a more comprehensive and complete representative sample. Your data doesn't seem to have clear logic of match apart from mere plugging in 1 and 2 dates to gender category. Or is that all the data is?

[KatLinden]

Yes, but I have hundreds of observations in dataset A, each observation has a unique ID and I need to insert 2 dates.

[novinosrin]

data a;
input ID  Gender $;
cards;
1     M
2     F
;
data b;
input Date $10.;
cards;
1/1/2010
1/2/2010
;
proc sql;
create table want as
select *
from a,b
order by id,gender;
quit;

[novinosrin]

still i am only playing with your data without making much sense lol 

[KatLinden]

That worked perfectly!  Thank you so much!