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 are the uses of sas?

1163

---

Name some categories in sas 9? : sas-grid-administration

912

---

What is the use of PROC gplot?

1066

---

In sas, what are the areas that you are most interested in? : sas-grid-administration

1018

---

what is the function of catx syntax? : Sas-administrator

1044

---

What is the difference between using drop = data set option in data statement and set statement?

1104

---

Mention the difference between ceil and floor functions in sas?

1097

---

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

1085

---

What is the difference between input and infile statement?

1109

---

What is substr function?

1115

---

what are the considerations when picking a SAS/STAT procedure?

3322

---

Give some examples where proc report’s defaults are same as proc print’s defaults?

1052

---

How do you specify the number of iterations and specific condition within a single do loop?

1045

---

explain the proc in sas? : Sas-administrator

1031

---

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2434

---