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 the purpose of trailing @ and @@? How do you use them?

805

---

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

792

---

What are the differences between sum function and using “+” operator?

815

---

Mention what are the data types does SAS contain?

931

---

What is the difference between SAS functions and procedures?

907

---

how many types prompting framework can be broken down to? : Sas-bi

857

---

How do dates work in SAS data?

932

---

What do you know about sas and what we do? : sas-grid-administration

818

---

what other sas products have you used and consider yourself proficient in using? : Sas programming

907

---

How does proc sql work?

837

---

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4160

---

Describe 5 ways to do a “table lookup” in SAS?

891

---

how does sas handle missing values in functions? : Sas programming

858

---

what are the component of range? : Sas-bi

835

---

What are the table names in oracle database...?

2512

---