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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.