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
- 5170 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 are symbol tables?Differemce between Local N Global Symbol tables.....
Are you involved in writing the inferential analysis plan? Tables specfications?
Which are SAS Windows Clients & SAS Java Clients
Name statements that are execution only.
how does sas handle missing values in assignment statements? : Sas programming
At compile time when a SAS data set is read, what items are created?
Why and when do you use proc sql?
how to read the variables in sas? : Sas-administrator
For what purpose would you use the RETAIN statement?
why is the use of Retrive statement and give me with example?
what are _numeric_ and _character_ and what do they do? : Sas programming
What would be the value of month at the end of data step execution and how many observations would be there?
Teradata 
