what are the methods that you would employ to fine tune
your SQL extract process using SAS/Access or Proc SQL?
Answer Posted / sastechies
Some answers that I know...
1.Remote Pass thru SQL (RSPT) using Proc SQL is the best
method to extract data from other DBMS.
2. Use the available INDEX on the table / SAS datasets.
3. Improvise on the WHERE expression to pull data that you
would only require...
4. When using SAS/Access use a high value for DBCOMMIT=
option (default is 1000 rows)
5. If someone is trying to extract data and then do certain
transformations and then loading back the data to the same
external database...then the best thing is to use RSPT and
write Native SQL statement using the EXECUTE Statements.
Anymore Please fill
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
how to debug and test the sas program? : Sas-administrator
What is the basic structure of the SAS base program?
How do dates work in SAS data?
For what purpose would you use the RETAIN statement?
what are informats in sas? : Sas-administrator
Which are the statements whose placement in the data step is critical?
Name and describe few sas character functions that are used for data cleaning in brief.
Explain the use of proc print and proc contents?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
What is the general format of function in sas? : sas-grid-administration
what is metadata? : Sas-bi
What are types of transport files?
What is SAS?
why is sas considered self-documenting? : Sas programming