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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.