Help using Base SAS procedures

Combining datasets

Reply
Contributor
Posts: 21

Combining datasets

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?

Super User
Posts: 9,687

Re: Combining datasets

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

Contributor
Posts: 21

Re: Combining datasets

Could you please provide the command?

Super Contributor
Posts: 349

Re: Combining datasets

Hi,

Data want;

set one two three four;

run;

Thanks,

Shiva

New Contributor
Posts: 4

Re: Combining datasets

Hi,

You can use contacatenate.

Here is code..

data output.

set input1

      input2;

run;

Thanks,

Trivikram.

Ask a Question
Discussion stats
  • 4 replies
  • 243 views
  • 0 likes
  • 4 in conversation