How would you identify a macro variable? : sas-macro

0 Answers  

---

/* 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 difference between sas rename and lable?

4 Answers  

---

what is SAS/Access and SAS/Connect?what are the uses?

3 Answers  

---

What is the role of administrative users? : sas-grid-administration

0 Answers  

---

what is hierarchy flattening? : Sas-di

0 Answers  

---

Describe how you would pass data to macro.

3 Answers  

---

whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?

1 Answers   Accenture,

---

what is sas data set?

0 Answers  

---

List down the reasons for choosing sas over other data analytics tools.

0 Answers  

---

Which command is used to save logs in the external file?

0 Answers  

---

How experienced are you with customized reporting and use of Data _Null_ features?

4 Answers   Oracle,

---