Interested to Buy Any Domain ? << Click Here >> for more details...
what are the methods that you would employ to fine tune
your SQL extract process using SAS/Access or Proc SQL?
- 1 Answers
- 5241 Views
- I also Faced
- E-Mail Answers
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 |
When you will use nowd option in report???
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
In proc transpose and data step with arrays which one you pick?
0 Answers Accenture, Quintiles,
What is the difference between an informat and a format. Name three informats or formats.
Name statements that function at both compile and execution time?
What are the rows present in protocol Violation table?
2 Answers Accenture, Quintiles,
what is lifetest
What is the maximum and minimum length of macro variable
What is the order of evaluation of the comparison && logical && relational operators:?
How many missing values are available? When might you use them?
what is factor analysis? : Sas-administrator
Name and describe three SAS functions that you have used, if any?
Teradata 
