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

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1480

---

What will calendar procedure do?

1065

---

How do you use the do loop if you don’t know how many times you should execute the do loop?

1251

---

: and & modifiers.

1380

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1085

---

Do you know the features of sas?

1034

---

is data integration and etl programming is same? : Sas-di

1068

---

What versions of SAS have you used (on which platforms)?

1504

---

what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

1023

---

What is the purpose of trailing @ and @@? How do you use them?

1031

---

what are validation tools that are used in sas? : Sas-administrator

1047

---

Which are the statements whose placement in the data step is critical?

1250

---

What are the special input delimiters used in SAS?

1167

---

Difference between nodup and nodupkey options?

1181

---

What are the ways to do a “table lookup” in sas?

1024

---