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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.