topic Re: Adding tables based on the same struture one after another in New SAS User

Adding tables based on the same struture one after another

PierreYvesILY — Thu, 01 Aug 2019 12:49:11 GMT

Hello,

I have n tables (>50) with the same variable names, and want to add them after another.

I want this result:

what should I do?

thanks in advance,

Re: Adding tables based on the same struture one after another

Kurt_Bremser — Thu, 01 Aug 2019 12:59:31 GMT

Use them in a single set statement, in the wanted order:

data want;
set
  set1
  set2
  ....
  set50
;
run;

Re: Adding tables based on the same struture one after another

PierreYvesILY — Thu, 01 Aug 2019 13:25:08 GMT

hello,

thanks.

This is the methods I use, but I hoped there would be something more practical to avoid typing all tables names - and that I would just not be aware of.

Have a nice day,

Re: Adding tables based on the same struture one after another

Kurt_Bremser — Thu, 01 Aug 2019 14:41:08 GMT

If the tables share a common prefix, you can use the colon wildcard; or if you have any other rule, you can use a select into from dictionary.tables to create a macro variable that holds the table names for the set statement.

Re: Adding tables based on the same struture one after another

PierreYvesILY — Thu, 01 Aug 2019 15:03:37 GMT

thank you.

I would need an example to understand how to use this.

Let's say all tables have the following name, ending with a number from 1 to n:

Prod_Week_1 to Prod_Week_n

I guess I now have to write :

Prod_Week_:

into the code.

data want;

set Prod_Week_: ;

run;

Is this correct?

the second proposed solution seems more complicated to me (I'm new to SAS), and I don't understand how to write this down in the code.

regards,

Re: Adding tables based on the same struture one after another

Kurt_Bremser — Thu, 01 Aug 2019 15:13:14 GMT

#1 is exactly what I was hinting at with wildcards.

#2 will look like this:

proc sql noprint; /* we don't need print output */
select catx('.',libname,memname) into :dsnames separated by ' '
from dictionary.tables
where libname = "XXXX" and /* add further suitable conditions here */
;
quit;

data want;
set &dsnames.;
run;

Re: Adding tables based on the same struture one after another

PierreYvesILY — Thu, 01 Aug 2019 15:23:05 GMT

Thanks a lot.

I'll be able to process the 52 files tomorrow now...

Have a nice evening,