topic Re: how to create two tables from select query? in SAS Studio

how to create two tables from select query?

paddyb — Mon, 20 Feb 2017 05:03:51 GMT

Below code I am creating two tables as a output of select query.macro parametere aa have 2 values so create 2 tables.I want to name the table from that.ANy idea how to do that

%macro dismon(aa);
proc sql;
select DISTINCT MONTH from raw102.&aa;
quit;
%mend;

data test;
set sashelp.vcolumn;
where libname="RAW102" and name="MONTH";
call execute('%dismon(' || memname || ');');
keep memname;
run;

Re: how to create two tables from select query?

Reeza — Mon, 20 Feb 2017 05:08:35 GMT

CREATE TABLE

See the docs for examples of usage.

http://support.sas.com/documentation/cdl/en/sqlproc/69822/HTML/default/viewer.htm#p1l9ypkml4febvn0zsbkwev7v5x9.htm

Re: how to create two tables from select query?

paddyb — Mon, 20 Feb 2017 05:12:03 GMT

create table data1 as select query

this create only one table

i want create table data1 data2 as select query

but its not allowed any other way of doing it

Re: how to create two tables from select query?

paddyb — Mon, 20 Feb 2017 05:14:37 GMT

create table will create 1 table.I want 2 tables as output of select query result in 2 table

Re: how to create two tables from select query?

Reeza — Mon, 20 Feb 2017 05:19:53 GMT

Search : split data into subsets.

Either here or Google.

There is a writeup on sascommunity.org and SAS Dummy blog.

There are at least a dozen solutions here, more like at least one a week.

Re: how to create two tables from select query?

paddyb — Mon, 20 Feb 2017 05:21:47 GMT

thank you.will check