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
- 5165 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
what is the Population you used in your project, is it ITT or PP?
how can you create zero observation dataset? : Sas programming
What are the advantages of using sas?
How long can a macro variable be? A token? : sas-macro
it will become easy if uuu provide website linkssss and list of consultanciessssss
what are validation tools that are used in sas? : Sas-administrator
What is a pdv and what are its functions?
what is treatment emergent events and treatment emregent adverse event
Explain the purpose of substr functions in sas programming.
List down the reasons for choosing sas over other data analytics tools.
What is a put statement?
how the sas basic syntax style described? : Sas-administrator
How does proc sql work?
how could you generate test data with no input data? : Sas programming
What is the use of function Proc summary?
