topic Re: Multiple proc sql tables with same prefix in SAS Programming

Multiple proc sql tables with same prefix

belboy — Wed, 01 May 2019 19:23:33 GMT

Hi SAS Community,

I'm having a problem trying to combine 20 datasets using proc sql. I can do it in a datastep, but is it possible to do with proc sql?

data want;

set have_: ; /*all of my datasets begin with have_*/ /*For instance, have_01, have_02, have_03....etc */

if dc_code = "" then total = total +1;

run;

Is it possible to perform this same procedure using proc sql?

Thanks

Re: Multiple proc sql tables with same prefix

novinosrin — Wed, 01 May 2019 19:30:30 GMT

Is it possible to perform this same procedure using proc sql?

Thanks

No because Proc sql doesn't support variable/dataset name lists. You could perhaps generate sql union operator statements in a macro or using call execute reading dictionary tables, but that's rather tedious.

Re: Multiple proc sql tables with same prefix

Reeza — Wed, 01 May 2019 19:36:45 GMT

Is it possible to perform this same procedure using proc sql?

It's possible by listing out the tables or creating a macro that unions all the tables.

Is it efficient or practical to do so? Not really.

@belboy wrote:

Hi SAS Community,

I'm having a problem trying to combine 20 datasets using proc sql. I can do it in a datastep, but is it possible to do with proc sql?

data want;

set have_: ; /*all of my datasets begin with have_*/ /*For instance, have_01, have_02, have_03....etc */

if dc_code = "" then total = total +1;

run;

Is it possible to perform this same procedure using proc sql?

Thanks