How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

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 the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?

8 Answers  

---

how do u test a pros sql(works or not) without executing it?

1 Answers   DELL, HSBC,

---

What is a macro routine?

0 Answers  

---

In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;

1 Answers  

---

How do you add a prefix to some or all variables in a dataset using a SAS macro?

2 Answers  

---

What is the good sas programming practices for processing large data sets?

0 Answers  

---

how to do user inputs and command line arguments in sas?

0 Answers   D&B, TCS,

---

what are the categories that sas informats are used to the place the data? : Sas-administrator

0 Answers  

---

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

0 Answers  

---

what is Enterprise Guide?what is the use of it?

2 Answers   CitiGroup, Oracle,

---