topic Re: Merging Problem in SAS Programming

Merging Problem

KatLinden — Wed, 23 May 2018 14:33:29 GMT

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?

Re: Merging Problem

novinosrin — Wed, 23 May 2018 14:47:26 GMT

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;

Re: Merging Problem

KatLinden — Wed, 23 May 2018 14:47:52 GMT

Thank you so much!

Re: Merging Problem

novinosrin — Wed, 23 May 2018 14:52:18 GMT

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

Re: Merging Problem

KatLinden — Wed, 23 May 2018 14:59:14 GMT

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

Re: Merging Problem

novinosrin — Wed, 23 May 2018 15:09:39 GMT

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?

Re: Merging Problem

KatLinden — Wed, 23 May 2018 15:11:35 GMT

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

Re: Merging Problem

novinosrin — Wed, 23 May 2018 15:13:48 GMT

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;

Re: Merging Problem

novinosrin — Wed, 23 May 2018 15:12:29 GMT

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

Re: Merging Problem

KatLinden — Wed, 23 May 2018 15:15:41 GMT

That worked perfectly! Thank you so much!