/* 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
- 4250 Views
- Emerio, I also Faced
- E-Mail Answers
Answer / muralavenu
Year and Day is fine. but Month is calculating from
current month onwords(i.e. ending to starting instead of
starting to ending). How to get rid of this problem. Plz
find out.
| Is This Answer Correct ? | 0 Yes | 0 No |
Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?
What areas of SAS are you most interested in?
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.
what are scrubing procedures in SAS?
What is the difference between a PROC step and a DATA step?
What are exact SAS Base contents..?N what r SAS Tools..?
what r the job openings SAS for fresher graduates !
Mention the validation tools used in SAS?
what is conditional processing?
how does sas handle missing values in functions? : Sas programming
Teradata 
