Answer Posted / pambrose

Here is the detailed usage of intnx function

date1=intnx('month','01jan95'd,5,'beginning');
put date1 / date1 date7.;

date2=intnx('month','01jan95'd,5,'middle');
put date2 / date2 date7.;

date3=intnx('month','01jan95'd,5,'end');
put date3 / date3 date7.;

date4=intnx('month','01jan95'd,5,'sameday');
put date4 / date4 date7.;

date5=intnx('month','15mar2000'd,5,'same');
put date5 / date5 date9.;

interval='month';
date='1sep2001'd;
align='m';
date4=intnx(interval,date,2,align)
;put date4 / date4 date7.;

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

1118

---

what is factor analysis? : Sas-administrator

1041

---

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1104

---

What areas of SAS are you most interested in?

1485

---

How to create a permanent sas data set?

1155

---

What is maximum number of rows and cols can be handled in SAS?

1508

---

Why and when do you use proc sql?

1200

---

it will become easy if uuu provide website linkssss and list of consultanciessssss

1930

---

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.

2110

---

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2414

---

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

1003

---

I need level 2 to 5 sas using companies in india

2341

---

What is program data vector (pdv) and what are its functions?

1167

---

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2078

---

What is the difference between INPUT and INFILE ?

1254

---