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

Can you explain the process of calendar?

1067

---

Mention the difference between ceil and floor functions in sas?

1109

---

Have you ever used the SAS Debugger?

1701

---

how would you create multiple observations from a single observation? : Sas programming

961

---

What is the basic structure of a sas program?

1064

---

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2071

---

What are the 3 components in sas programming?

1155

---

How to read an input file in sas?

1102

---

What is the difference between input and infile statement?

1119

---

How we can create SAS USER DEFINED CODE?

2038

---

Describe crosslist option in tables statement?

1180

---

What is the basic syntax of a sas program?

1155

---

How to create an external dataset with sas code?

1082

---

How to create a permanent sas data set?

1149

---

what are the benefits of data integration? : Sas-di

1035

---