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?
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
Could you please provide the command?
Hi,
Data want;
set one two three four;
run;
Thanks,
Shiva
Hi,
You can use contacatenate.
Here is code..
data output.
set input1
input2;
run;
Thanks,
Trivikram.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.