What is LAG function?How is it used? can any one explain

3 Answers   TRE, Verinon Technology Solutions,

---

explain the proc in sas? : Sas-administrator

0 Answers  

---

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?

6 Answers   Accenture,

---

/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;

1 Answers   Emerio,

---

What is the use of function Proc summary?

0 Answers  

---

---

What is Transaction...? And what are Comment, Roll back n Save point..?

2 Answers  

---

How do you connect the desktop application to metadata server? : sas-grid-administration

0 Answers  

---

What can be the size of largest dataset in SAS?

0 Answers  

---

what is hierarchy flattening? : Sas-di

0 Answers  

---

Name some categories in sas 9? : sas-grid-administration

0 Answers  

---

How would you code a macro statement to produce information on the SAS log? This statement can be coded anywhere.

8 Answers  

---

Where do the database management systems store data and how do u import them.

2 Answers   L&T,

---