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 |
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
which domain is better in sas? clinical trails or banking
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
Did you used proc test? when?
0 Answers Accenture, Quintiles,
how we can create optional or required parameters in SAS macro...
What is SAS informats?
List out some key concept of SAS
What can you learn from the SAS log when debugging?
What does PROC print, and PROC contents do?
What are TEAEs
2 Answers Accenture, Quintiles,
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
how do you read binary data in sas?