topic Re: How to add a new record at the top of dataset in SAS Programming

How to add a new record at the top of dataset

SasPro — Wed, 17 Apr 2013 07:30:43 GMT

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

RichardinOz — Wed, 17 Apr 2013 07:47:46 GMT

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

Richard

LinusH — Wed, 17 Apr 2013 07:49:04 GMT

What is the requirement?

SasPro — Wed, 17 Apr 2013 07:56:46 GMT

data datasetA;

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

run;

Hey got it

thank u

RichardinOz — Wed, 17 Apr 2013 08:01:47 GMT

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

Richard