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

Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2601

---

what is the difference between infile and input? : Sas-administrator

1132

---

What is your favorite all time computer book? Why?

2502

---

Are you sensitive to code walk-throughs peer review or QC review?

3139

---

What are pdv and it functions?

1132

---

for report generation which one you used proc report or data_null_?

7767

---

What is the difference between SAS functions and procedures?

1144

---

What do you code to create a macro? : sas-macro

1127

---

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

1007

---

Mention the category in which sas informats are placed?

1011

---

what is business intelligence? : Sas-bi

1056

---

what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1223

---

What do you understand by the term Normal Distribution?

979

---

what do you mean by data staging area? : Sas-di

1131

---

what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

1014

---