Hi all,
I have two datasets,
DatasetA
----------------
Name$ age place$
F 24 NJ
D 85 NY
B 34 AC
DatasetB
----------------
Name$ age place$
C 45 BM
F 54 NY
I want to add the first OBS to from datasetB(C 45 BM) to datasetA
the datasetA should the records as
DatasetA
----------------
Name$ age place$
C 45 BM
F 24 NJ
D 85 NY
B 34 AC
thank you in advance
data datasetA;
set datasetB(firstobs=1 obs=1) datasetA;
run;
Hey got it
thank u
This looks like a homework question to me. Explore the set statement and the obs= option.
Richard
What is the requirement?
data datasetA;
set datasetB(firstobs=1 obs=1) datasetA;
run;
Hey got it
thank u
Good. Firstobs is redundant (not needed here) because firstobs=1 by default.
Richard
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.