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
- 5164 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 the efficacy variables in your study?
2 Answers Accenture, Quintiles,
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
What is the basic structure of the SAS base program?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
Explain what is data step?
why is sas considered self-documenting? : Sas programming
/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
What is the difference between class statement and by statement in proc means?
what is the primary variable in your study?
how can you improve the performance of a query, If it is excuting very slowly?
what is the primary data source for the wrs? : Sas-bi
Teradata 
