topic Re: Combining datasets in SAS Procedures

Combining datasets

ncross — Tue, 12 Jun 2012 02:38:43 GMT

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?

Re: Combining datasets

Ksharp — Tue, 12 Jun 2012 03:16:51 GMT

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

Re: Combining datasets

ncross — Tue, 12 Jun 2012 06:30:25 GMT

Could you please provide the command?

Re: Combining datasets

shivas — Tue, 12 Jun 2012 09:17:06 GMT

Hi,

Data want;

set one two three four;

run;

Thanks,

Shiva

Re: Combining datasets

Trivikram — Mon, 30 Jul 2012 07:39:54 GMT

Hi,

You can use contacatenate.

Here is code..

data output.

set input1

input2;

run;

Thanks,

Trivikram.