topic Re: merge mix of tables in New SAS User

merge mix of tables

MargoBlue — Fri, 14 Feb 2020 15:08:33 GMT

Please could you explain what makes ':' after the name of the table?

Re: merge mix of tables

PeterClemmensen — Wed, 05 Feb 2020 07:14:53 GMT

It simply means 'all the table names starting with cost2'...

See this small example

data cost1;
id = 1; x = 2;
run;

data cost2;
id = 1; y = 3;
run;

data cost3;
id = 1; y = 3;
run;

data want;
   merge cost:;
   by id;
run;

Re: merge mix of tables

Patrick — Wed, 05 Feb 2020 09:29:06 GMT

@MargoBlue wrote:
Please could you explain what makes ':' after the name of the table? It merges tables cost1 cost3 cost4 and tables from cost33 to cost37?

merge cost1-cost4 cost2: cost33-37;

It's just like a wildcard and will pick any table starting with name cost2 - i.e. cost212 cost2abc .....

Docu here.