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
- 5224 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 |
In ARRAY processing, what does the DIM function do?
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
/*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
Write a SAS macro to calculate number of numbers in an email address
what is data governance? : Sas-di
what are the benefits of data integration? : Sas-di
what type of graphs we will create(for 2+years candidates)?
Explain the difference between using drop = data set option in set and data statement?
What are the limitations for memory allocation for SAS variables
How would you code the criteria to restrict the output to be produced?
Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?
Teradata 
