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?
Thank you so much!
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;
Thank you so much!
@KatLinden Welcome to the SAS community forum. I hope you have a fun journey with us 🙂
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
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?
Yes, but I have hundreds of observations in dataset A, each observation has a unique ID and I need to insert 2 dates.
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;
still i am only playing with your data without making much sense lol
That worked perfectly! Thank you so much!
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.