topic Re: How to add observations to a dataset in SAS Data Management

How to add observations to a dataset

SaiSwaroop — Thu, 29 Oct 2015 17:29:05 GMT

Hi friends,

For suppose i have a program :

data demo;

set oracle_data;

run;

Let us say oracle_data dataset have 100 observaions , so our demo should also have 100 observations if i want to add 10 more observations to demo dataset which are not present in oracle_data.

How do i do this?

Can i use datalines statement here? To append new observations?

Thanks in advance .

Re: How to add observations to a dataset

kannand — Thu, 29 Oct 2015 17:35:33 GMT

data subset10;
set oracle_data(obs=10);
run;
data demo;
set oracle_data subset10;
run;

One way you can add is by adding another dataset which is a subset of what you have and limit to 10

Re: How to add observations to a dataset

Reeza — Thu, 29 Oct 2015 17:35:24 GMT

It depends on where your observations are coming from.

One way is to create a new dataset with the observations, using either cards and then append the datasets.

You can use either proc append, a data step or a union all step in proc sql, as a few options.

Re: How to add observations to a dataset

pic_sas — Fri, 30 Oct 2015 09:55:19 GMT

Hi,

Simply store those additional observations (10 from your example) in a separate dataset and user Proc Append after the data step that you have.