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 |
what is TAB delimiter? explain about it? what will you do to get TAB delimiter?
tell me about intnx, intcx functions?
Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?
how to perform paired t-test using Base/SAS & SAS/Stat?
What is the difference between SAS Data step and SAS PROC SQL, and which is better?
Explain input and put function?
i want to upload titles and footnotes to excel file?how it is possible?
Given an unsorted data set, how to read the last observation to a new data set?
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 the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
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...
Are you sensitive to code walk-throughs peer review or QC review?