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

why is a stop statement needed for the point=option on a set statement? : Sas programming

1128

---

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

1057

---

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

1041

---

What is the role of administrative users? : sas-grid-administration

1134

---

explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

1140

---

What is substr function?

1239

---

What is the use of stop statement?

1111

---

Which function is used to count the number of intervals between two sas dates?

1189

---

How do you convert basic cube to transaction cube and transaction cube to basic cube?

2286

---

Explain what is the use of proc gplot?

1245

---

What is the difference between order and group variable in proc report?

1480

---

what is program data vector? : Sas-administrator

1122

---

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

1186

---

How would you identify a macro variable?

1137

---

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1198

---