Hi, I tried to get just 10 observations sample from a large database server. but I had to wait 8 hours to get these 10 observations. Is there a quick way to get it?
Thanks
Hi @bohonghong;
Please refer this document for speed up your processing;
Because too many parameters we have to check to speed up the processing;
this link will give you proper idea about PROC SURVEYSELECT and its options to speed up this procedure,
Link : http://www2.sas.com/proceedings/forum2007/183-2007.pdf
Thanks.
How large is your data? What is you DB? What code you used for that?
I couldn't find how many observation on my server database, the ROW showing Unknown. and it is created like 1960.
Would need to know further information to help, DB used, code etc. However, if you just want 10 observastions from a database, why not just go onto the database, runs some SQL and drop the results into a CSV. Probably quickest option unless you are planning to do it regularly?
Sorry, you have totally lost me there. You said you were having problems getting data from a database (DB) server. So I have responded with, why not go back to the database server and extract the data you want. You have now posted something about a proc surveyselect, which is a SAS procedure? Please clarify what you have problems with. I would also check, do you extract the data to a SAS dataset first, or are you doing this surveyselct on libnames to a database? Post your full code if possible.
This is about query performance, so EG is probably not the "problem". Are you using the Query Builder?
When you say "large database server", can you be a bit more specific? Vendor/version...
Share the code/log from your not so well performing query.
Chances are that your subset criteria is not evaluated in the source database, so that all records are moved to SAS.
Add
options sastrace=',,,d' sastraceloc=saslog nostsuffix msglevel=i;
to your code, and your will get information in log on what is going on, and where.
It may also depend on how the data base table is defined (lack of indexes, no/old index statistics, no/bad partitioning).
SASApp is the "name" of your SAS server where your code executes.
It's your library definition that tells you where your data is actually stored. Try:
libname _all_ list;
to get information about your source data base.
If it's non-SAS, you have two major options:
If this is SAS data, you definitely need to look at the SAS server, physical data storage and CPU/memory capacity.
Add:
options fullstimer;
to better analyse your SAS code excution.
Well now. When I wanna check the log. It is blank and my SAS EG is now frozen, it won't minimize and I had to use task manager to close it. Bummer
No, it's Oracle.
Hi @bohonghong;
Please refer this document for speed up your processing;
Because too many parameters we have to check to speed up the processing;
this link will give you proper idea about PROC SURVEYSELECT and its options to speed up this procedure,
Link : http://www2.sas.com/proceedings/forum2007/183-2007.pdf
Thanks.
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.