what are the methods that you would employ to fine tune
your SQL extract process using SAS/Access or Proc SQL?
Answer / 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 |
In sas admin differentiate between roles and capabilities? : sas-grid-administration
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
What is connection profile? : sas-grid-administration
Tell me more about the parameters in macro? : sas-macro
What are the five ways to do a table lookup in sas? : sas-grid-administration
How can I remove header from output data set?
Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?
How would you compile all macros from a folder in a study, within the autoexec program?
explain the use of % includes a statement in sas? : Sas-administrator
how many types prompting framework can be broken down to? : Sas-bi
What is the difference between verification and validation?
how does sas handle missing values in sort order? : Sas programming