BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SasPro
Calcite | Level 5


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

1 ACCEPTED SOLUTION

Accepted Solutions
SasPro
Calcite | Level 5

data datasetA;

set datasetB(firstobs=1 obs=1) datasetA;

run;

Hey got it

thank u


View solution in original post

4 REPLIES 4
RichardinOz
Quartz | Level 8

This looks like a homework question to me.  Explore the set statement and the obs= option.

Richard

LinusH
Tourmaline | Level 20

What is the requirement?

Data never sleeps
SasPro
Calcite | Level 5

data datasetA;

set datasetB(firstobs=1 obs=1) datasetA;

run;

Hey got it

thank u


RichardinOz
Quartz | Level 8

Good.  Firstobs is redundant (not needed here) because firstobs=1 by default.

Richard

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1155 views
  • 0 likes
  • 3 in conversation