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;
CREATE TABLE
See the docs for examples of usage.
create table will create 1 table.I want 2 tables as output of select query result in 2 table
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
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.
thank you.will check
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.