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
- 5156 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 work of tranwrd function?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
What is SAS?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
What are the table names in oracle database...?
Explain the difference between informat and format with an example.
what is study design in while working with SAS? what are screening variables in SAS?
How to limit decimal places for variable using proc means?
how does sas handle missing values in formats? : Sas programming
what are _numeric_ and _character_ and what do they do? : Sas programming
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Differentiate between ceil and floor functions.
where are dashboard components are created and maintained? : Sas-bi
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
