Answer Posted / h r

proc sql:-
use into:<var_name> to count observation recall by &<var_name>.

table limit in sql now 256(previously its was 32).

proc report now BEST12. format default for numeric value.
before there isn't any default format for numeric value in proc report.

NEW Options noward in proc freq.

what is slowly changing dimension? : Sas-di

1186

---

How to create an external dataset with sas code?

1246

---

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.

2199

---

What is connection profile? : sas-grid-administration

1232

---

What is the basic syntax of a sas program?

1264

---

which date function advances a date, time or datetime value by a given interval? : Sas programming

1097

---

Explain the use of proc print and proc contents?

1014

---

Differentiate input and infile.

1150

---

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

3419

---

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

1321

---

what are all the reports you generated in your recent project?

2253

---

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1262

---

Describe the function and utility of the most difficult SAS macro that you have written?

2627

---

Given an unsorted data set, how to read the last observation to a new data set?

1410

---

In SAS explain which statement does not perform automatic conversions in comparisons?

1372

---