/* 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;
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 |
how do u validate the program which u have written.
what is sas data set?
What Proc glm does?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
what is treatment emergent events and treatment emregent adverse event
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
What SAS statements would you code to read an external raw data file to a DATA step?
What is the Program Data Vector (PDV) and What are its functions?
what is sas? is a package or tool? give me introduction about sas?
How do you debug and test your SAS programs?
Can we replace a dataset into view?