Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Attempting to calculate age in sas

Status
Not open for further replies.
sap1958

sap1958

Technical User
Oct 22, 2009
138
0
0
US
data table2;
set table1;
Age = Birthdate-TODAY();
format TotalSalary dollar12.2;
run;

When I run this I get a large number for the Age.
ie 209501348

I should only get a 2 digit number
 
Sort by date Sort by votes

Have a go at this

data table2;
set table1;

tday = date();

age = floor((intck('month',Birthdate,tday)- (day(tday) < day(Birthdate))) / 12);

Where Birthdate is the date you want to see there age from.
 
Upvote 0 Downvote
Why cant you do it with just using the INTCK function without all the rules?

ex.
age = intck('year',Birthdate,date());
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question
How to create a new column in a SAS Data Studio Code Transform step?
Replies
0
Views
152
TheBugSlayer
TheBugSlayer
Anna dlC
  • Locked
  • Question
macro variables overwriting each other in loop
Replies
0
Views
103
Anna dlC
Anna dlC
Gaaya
  • Locked
  • Question
Winzip Encryption via SAS
Replies
1
Views
88
klaz2002
klaz2002
TechSlinger
  • Locked
  • Question
Updating SAS Dataset With Files in Sequential Order
Replies
0
Views
84
TechSlinger
TechSlinger
Ken
  • Locked
  • Question
how can we filter on yyyymm in proc sql ?
Replies
1
Views
249
klaz2002
klaz2002

Part and Inventory Search

Sponsor

Back
Top