Answer Posted / abhilash

by using index we search a particular string or sub string
it returns the position where the sub string is located
for ex:
data index;
name="india is greatest country";
idx-index(name,"great");
run;
it returns the great sub string position(10)

What are the data types in sas?

1112

---

for report generation which one you used proc report or data_null_?

7931

---

Mention what is the difference between nodupkey and nodup options?

1058

---

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1118

---

if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

1444

---

Explain the difference between informat and format with an example.

1218

---

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.

2198

---

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

2625

---

Why double trailing @@ is used in input statement?

1265

---

What are the functions which are used for character handling functions?

1189

---

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

1152

---

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

1209

---

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

1073

---

What is PDV?

1204

---

Mention how to limit decimal places for the variable using proc means?

1169

---