Answer / raghava pamulapati

by using pass through facility in sql we can read directly
with out conversion

Answer / ram

libname libref path='ram.xls';

Answer / ram

proc Import datafile='file path\ram.xls out=output
dbms=excel replace;
sheet='sheet$4;
run;

In which case u go for libname and in which case u go for proc sql pass thru facilit diff?

1 Answers  

---

I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

0 Answers  

---

When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

2 Answers   Accenture,

---

If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

7 Answers   Accenture,

---

IS SAS COMPILER OR INTERPRETER? EXPLAIN?

3 Answers   Aon Hewitt, HSBC, SCL, TCS,

---

Give some ways by which you can define the variables to produce the summary report (using proc report)?

0 Answers  

---

what is the difference between nodup and nodupkey options? : Sas programming

0 Answers  

---

explain the function of substr in sas? : Sas-administrator

0 Answers  

---

how do the in= variables improve the capability of a merge? : Sas programming

0 Answers  

---

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

0 Answers   Quintiles,

---

How sas treats the dsd delimiters?

0 Answers  

---

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

0 Answers  

---