Hi,
I'm also having a problem with EG saying "collecting" for a long time. Running EG 4.3 Win XP connecting to a Linux server. If I run:
data a;
set sashelp.shoes;
do i=1 to 5;
output;
end;
run;
It takes about 4.5 seconds to run. Most of that time it says "collecting". I have turned off the option to automatically open data/results. So in my head, all I think it sould be collecting is the SAS log.
As Jan suggested above, I turned on the logging per:
http://support.sas.com/kb/17/730.html
I dont see any obvious errors.
But I did notice that about 1.7 seconds of processing time is doing something with all of the metadata libnames that are automatically assigned (and not being used). So I see a series of blocks like:
2012-10-24 16:30:13,212 [3] DEBUG SAS.BI.SASComb.Method [(null)] - InvokeMethod::IsTemp
2012-10-24 16:30:13,212 [3] INFO SAS.EG.SDS.Model.LibraryState [(null)] - Attach() Name = MYLIB, Status = new
2012-10-24 16:30:13,244 [3] DEBUG SAS.BI.SASComb.Method [(null)] - InvokeMethod::IsReadOnly
2012-10-24 16:30:13,244 [3] DEBUG SAS.BI.SASComb.Method [(null)] - Leaving for IsTemp
2012-10-24 16:30:13,259 [3] DEBUG SAS.BI.SASComb.Method [(null)] - InvokeMethod::UseLibref
2012-10-24 16:30:13,259 [3] DEBUG SAS.BI.SASComb.Method [(null)] - Leaving for IsReadOnly
2012-10-24 16:30:13,291 [3] DEBUG SAS.BI.SASComb.Method [(null)] - InvokeMethod::IsTemp
2012-10-24 16:30:13,291 [3] DEBUG SAS.BI.SASComb.Method [(null)] - Leaving for UseLibref
2012-10-24 16:30:13,291 [3] DEBUG SAS.BI.SASComb.Method [(null)] - Re-using object 0x16.
So my questions:
1. Does 4.5 seconds seem obscenely long EG to run that data step? (The step itself runs on <.01 seconds, per the log).
2. Does above log suggests I am paying a huge performance price for having lots of library auto assigned (1.7 seconds for library handling /4.5 seconds for whole job = 38% ! )
3. Assuming I fail to convince the SAS admin that we don't need all thes libraries autoassigned, should they be able to set it up so that individual users can choose whether or not they want them auto assigned? (currently if I try to unassign them from within EG, I get an error).
4. In general, are people for/against auto assigning libnames. I had already been concerned about them because they result in bloated dictionary tables. Given this apparent performance hit, I'm liking them even less....
I always assumed the issue was network delays, as I'm dealing with a server far away. But seeing these logs gives me hope that the solution could be easier.
Thanks for any thoughts,
--Q.
The Boston Area SAS Users Group is hosting
free webinars!
Next up:
Joe Madden & Joseph Henry present Putting Power into the Hands of the Programmer with SAS Viya Workbench on Wednesday Nov 6.
Register now at
https://www.basug.org/events.
