Hi Everyone, thank you for reading the post.
I combined 24 datasets using the following code:
data conso.agloan;
set conso.agloan1993 conso.agloan1994 conso.agloan1995 conso.agloan1996 conso.agloan1997 conso.agloan1998 conso.agloan1999 conso.agloan2000 conso.agloan2001 conso.agloan2002 conso.agloan2003 conso.agloan2004 conso.agloan2005 conso.agloan2006 conso.agloan2007 conso.agloan2008 conso.agloan2009 conso.agloan2010 conso.agloan2011 conso.agloan2012 conso.agloan2013 conso.agloan2014 conso.agloan2015 conso.agloan2016;
run;
It works. But is there any trick to do it smarter without actually typing each dataset, something like
data conso.agloan;
set conso.agloan1993 - conso.agloan2016;
run;
Thank you in advance.
Or if you want ALL of the agloan sets in the library:
data conso.agloan;
set conso.agloan: ; /* note the : that indicates the list operator */
run;
If your individual sets are largish there may be a time penalty due to the way SET works and a series of Proc Append Calls may be quicker to execute. Unfortunately Proc Append only uses two data sets and not the shortcut list.
did your something like
data conso.agloan;
set conso.agloan1993 - conso.agloan2016;
run;
work?????
Or if you want ALL of the agloan sets in the library:
data conso.agloan;
set conso.agloan: ; /* note the : that indicates the list operator */
run;
If your individual sets are largish there may be a time penalty due to the way SET works and a series of Proc Append Calls may be quicker to execute. Unfortunately Proc Append only uses two data sets and not the shortcut list.
If all the tables are in specific library and have a defined prefix or suffix then you can get those table list by running query on dictionary.tables
proc sql;
select distinct memname into: SET_Tables separated by " "
from dictionary.tables
where libname="CONSO" and memname like 'AGLOAN%';
quit;
data want;
set &SET_Tables;
run;
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.