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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: