Good question. What am I trying to accomplish? I’m trying to figure out what SAS procs I need. I think just learning what SAS procedures are and do and what a site has is an iterative process, like modeling is. :smileymischief: Kinda like data mining too...    Reviewing my ETS on SAS v 9.1.3 on NT and v 9.2 on Unix and also EM 6.1 on Unix is an adventure.   I want to forecast up to 90 time series of non transactional data, now for the past 3 years. Forecast maybe a month or two ahead. Nothing missing. Proc Expand seems to be necessary for interpolation of missing data  and other procs handle different interval manipulation I think. My data comes from some daily input system that appears to have a ‘seasonal’ ie, end of month large dump of data. No regressors.  I just found Proc SGPlot (v 9.2 necessary) gives nice plots of multiple series and it has a nice group option. Right now it looks like Proc Timeseries on SAS 9.2 gives the easiest ways to look at seasons cycles and trends.  Proc ESM gives some estimates of about 6 types of smoothing models. It appears to not need any Proc Timeseries data as input, but I need to investigate. So far I haven’t  got very good results. I was hoping EM 6.2 might have a nice way to pick the right models but I seem to have only the timeseries module which I now see is probably just Proc Timeseries. I think I would need proc HPF do actually forecast and that is a separate product from ETS procs I think. How am I doing? ... View more

Ok I get it. It was too simple a question. I was in the middle of a time crunch and had deleted the docked version. I kept looking in the Tools=>Options window but it is in the View drop down. My work around was to do an extra set to get the datasets of interest to appear in the project list... ... View more

Bingo! I see ! I see! I see those librefs! Great idea! It helps those of us going blind from squinting at this stuff... ... View more

Thanks for that SPR: I tried that tip and used this code to review but it didn't seem to land my _mylib on top of that list : title "Current Libraries"; proc sql; select distinct(libname) from sashelp.vlibnam; quit; ... View more

Chris: Thanks for the code, it didn’t quite work on my system. proc sql; 15 create table currentFiles as 16 select fileref, 17 xpath, modate, 18 directory 19 from dictionary.extfiles 20 where substr(fileref,1,1) ne "#"; ERROR: The following columns were not found in the contributing tables: directory, modate. This is what worked: proc sql; create table currentFiles as select * from dictionary.extfiles where substr(fileref,1,1) ne "#"; quit; ... View more

OK Thanks Chris, Because the window has a zillion little filedrawers in the window I didn't see that there was some yellow ones that are my active libs and my friend Thomas texted me from afar that I MUST refresh with the right click. Is there sas code to write to find the active filerefs? ... View more