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 Rhinorhino 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
Joined
Oct 22, 2009
Messages
138
Location
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 Question
How to create a new column in a SAS Data Studio Code Transform step?
Replies
0
Views
793
TheBugSlayer
TheBugSlayer
Anna dlC
  • Locked
  • Question Question
macro variables overwriting each other in loop
Replies
0
Views
568
Anna dlC
Anna dlC
Gaaya
  • Locked
  • Question Question
Winzip Encryption via SAS
Replies
1
Views
609
klaz2002
klaz2002
TechSlinger
  • Locked
  • Question Question
Updating SAS Dataset With Files in Sequential Order
Replies
0
Views
423
TechSlinger
TechSlinger
Ken
  • Locked
  • Question Question
how can we filter on yyyymm in proc sql ?
Replies
1
Views
1K
klaz2002
klaz2002

Part and Inventory Search

Sponsor

Back
Top