what are the methods that you would employ to fine tune
your SQL extract process using SAS/Access or Proc SQL?



what are the methods that you would employ to fine tune your SQL extract process using SAS/Access ..

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

Post New Answer

More SAS Interview Questions

What function CATX syntax does?

0 Answers  


How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

0 Answers  


Tell e how how dealt with..

0 Answers  


I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

0 Answers  


How can I remove header from output data set?

0 Answers  


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

0 Answers  


What is the basic structure of a sas program?

0 Answers  


Give an example where SAS fails to convert character value to numeric value automatically?

0 Answers  


What is the difference between Proc tabulate and Proc print

4 Answers   CitiGroup,


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

0 Answers  


What is the function of output statement in a SAS Program?

0 Answers  


What is a put statement?

0 Answers  


Categories