Combining datasets

[ncross]

I'm looking to combine 8 seperate datasets into one large dataset. They each contain the same information just for different time periods.

Upon first attempt I used the merge function. But this can't be right.

For example; dataset 1 has 232,000 observations, dataset 2 has 500,000 observations. I would want my 1 + 2 datasets to hold 732,000 pbservations. But under the merged function it only holds 232,000.

How do I solve for this?

[Ksharp]

For example; dataset 1 has 232,000 observations, dataset 2 has 500,000 observations. I would want my 1 + 2 datasets to hold 732,000 pbservations. 

That means you want union these two datasets vertically , You should use SET statement or PROC APPEND.

While MERGE is used to union horizontally .

Ksharp

[ncross]

Could you please provide the command?

[shivas]

Hi,

Data want;

set one two three four;

run;

Thanks,

Shiva

[Trivikram]

Hi,

You can use contacatenate.

Here is code..

data output.

set input1

      input2;

run;

Thanks,

Trivikram.