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
- 5239 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 primary data source for the wrs? : Sas-bi
Explain what is SAS informats?
What does P-value signify about the statistical data?
Describe the function and utility of the most difficult SAS macro that you have written?
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
What Proc glm does?
describe the interaction table in sas di? : Sas-di
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
I have a dataset concat having variable a b & c. How to rename a b to e & f?
how to read the variables in sas? : Sas-administrator
Explain input and put function?
What do you know about sas data set?
Explain the purpose of substr functions in sas programming.
what is the use of proc sql? : Sas programming
What is the difference between nodupkey and nodup options?
