what are the methods that you would employ to fine tune
your SQL extract process using SAS/Access or Proc SQL?



what are the methods that you would employ to fine tune your SQL extract process using SAS/Access ..

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

Post New Answer

More SAS Interview Questions

what is TAB delimiter? explain about it? what will you do to get TAB delimiter?

3 Answers   Cap Gemini,


tell me about intnx, intcx functions?

4 Answers   CitiGroup,


Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?

3 Answers  


how to perform paired t-test using Base/SAS & SAS/Stat?

2 Answers  


What is the difference between SAS Data step and SAS PROC SQL, and which is better?

1 Answers   TCS,


Explain input and put function?

0 Answers  


i want to upload titles and footnotes to excel file?how it is possible?

1 Answers  


Given an unsorted data set, how to read the last observation to a new data set?

0 Answers  


If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?

1 Answers   HCL, Quintiles,


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

0 Answers  


I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,


Are you sensitive to code walk-throughs peer review or QC review?

0 Answers   Quintiles,


Categories