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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.