topic Re: having same variable (392) and different no. of observation for 10 datasets and wants to merge or join in SAS Enterprise Guide

having same variable (392) and different no. of observation for 10 datasets and wants to merge or join

sas_9 — Mon, 14 Jan 2013 19:39:22 GMT

Hello Genius,

I have 10 datasets with same no. of variables (392) and same variable names for all datasets. Each dataset having massive no. of observation and i want to join/merge each and every datasets in to one making "ONE BIG DATASET" with all observation from all datasets.

What is the best practice to do so?

Please advise....

Thanks.

Re: having same variable (392) and different no. of observation for 10 datasets and wants to merge or join

Linlin — Mon, 14 Jan 2013 19:48:08 GMT

Do you want to merge or set? if you want to merge you have to rename some of your variables first.

Re: having same variable (392) and different no. of observation for 10 datasets and wants to merge or join

Reeza — Mon, 14 Jan 2013 19:48:44 GMT

Are you merging the files by a common variable (10 files * 392 variables ~= 3920 variables ) or appending them together (still 392 variables at the end)?

Re: having same variable (392) and different no. of observation for 10 datasets and wants to merge or join

sas_9 — Mon, 14 Jan 2013 20:02:43 GMT

@ Reeza - adding observation from all 10 datasets and will stay with 392 variables at the end - appreciate your reply...

@Linlin - I am not sure whether i am going to merge or set but again will stay with same no. of variable (392) and adding observations from all 10 datasets...- Thanks

Re: having same variable (392) and different no. of observation for 10 datasets and wants to merge or join

Linlin — Mon, 14 Jan 2013 20:10:19 GMT

try:

data want;

set data1 data2 ...data10;

run;

Re: having same variable (392) and different no. of observation for 10 datasets and wants to merge or join

sas_9 — Wed, 16 Jan 2013 17:09:11 GMT

Thanks Linlin...Thanks you all for your feedback