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 */

what is metadata? : Sas-bi

825

---

what are some differences between proc summary and proc means? : Sas programming

805

---

describe about metadata object? : Sas-di

867

---

name the scheduler for scheduling job and explain the scheduler? : Sas-di

852

---

What is the use of the %include statement?

931

---

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1355

---

what versions of sas have you used (on which platforms)? : Sas programming

852

---

Mention the difference between ceil and floor functions in sas?

939

---

What are the default statistics that proc means produce?

828

---

what is transformation in sas data integration? : Sas-di

812

---

What is program data vector (pdv)?

890

---

how to do user inputs and command line arguments in sas?

2719

---

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

993

---

what are sas bi dashboard components? : Sas-bi

917

---

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2202

---