how to create two tables from select query?

[paddyb]

Hi

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;

[Reeza]

CREATE TABLE 

See the docs for examples of usage. 

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

[paddyb]

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

[paddyb]

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

[Reeza]

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. 

[paddyb]

thank you.will check