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
- 5155 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 |
What is factor analysis?
what do you mean by data staging area? : Sas-di
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
Define run-group processing?
what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter?
36 Answers Accenture, College School Exams Tests, CTS, IBM, IHRD, Infosys, Sylhet Engineering College, TCS, Wipro,
what is slowly changing dimension? : Sas-di
% let A=3+4 what is result
How would you code the criteria to restrict the output to be produced?
what are the types of interactive display types? : Sas-bi
Mention the validation tools used in SAS?
do you need to know if there are any missing values? : Sas programming
how do you want missing values handled? : Sas programming
Teradata 
