Answer Posted / paul

we can read by a simple libname access method:

eg:
libname exlbook 'd:\excel file location\file name.xls';
proc copy in=exlbook out=work;
run;

/*here i am coying the entire excel workbook to work library
in sas, so we can get all sheets at a time.
if we use proc import we can import a single sheet at a time
By the above method we can dump all table from a MS-access database or oracle database or any other db.
only we have to change the connection details, i.e.,

excel --> file name with path
access --> db name with path
oracle/any other RDBMS --> user=***, password=****,
path=**** or host=****

another advantage of this method is :
the library will not occupy any memory on hard disc
it only acts as a repository which save memory and
processing time */

how many types of prompts are there? : Sas-bi

1081

---

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

1145

---

What is run-group processing?

1171

---

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2373

---

How to include or exclude specific variables in a data set?

1123

---

How do you add a number to a macro variable? : sas-macro

1014

---

Differentiate between ceil and floor functions.

1163

---

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

1438

---

what is sas application server? : Sas-di

1084

---

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1041

---

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

1195

---

What is the purpose of _character_ and _numeric_?

1068

---

Difference between informat and format?

1098

---

How would you identify a macro variable?

1097

---

Give e an example of..

2346

---