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
- 5313 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 |
Hi I have list of products in a dataset, which are classified by other name for eg:- there is a product A> Malambo Shiraz Malbec 750ML(0388) which is a Red wine.Now i need to generate a report where it shows if this product appears then it should b displayed as red wine,similarly for other products and other classification. I dont wan use proc format.
What is the difference between %put and symbolgen? : sas-macro
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
what type of graphs we will create(for 2+years candidates)?
Enlist the syntax rules followed in sas statements.
Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?
5 Answers American Express, Barclays,
what is sas business intelligence? : Sas-bi
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
how does sas handle missing values in functions? : Sas programming
How to Rename Library?
How you can read the variables that you need?
Teradata 
