Information is one of the many variables in my SAS dataset. The observations are more than couple hundreds. Is there something better than infile statement? where I don't have to enter the variable values?  ... View more

Yes I want them as the null values as the sample want has. ... View more

Thank you so much! This worked like a charm! ... View more

options yearcutoff=1910;   data B; set A; b_date=datepart(birthdate); format b_date date.; date=today(); Age_exact = floor((intck('month',b_date,Date)-(day(Date) < day(b_date))) / 12); format date date9.; run;   Still getting negative age ... View more

Given the age of the population in the dataset I working with. I am thinking it is 1922. I'm still getting negative value after setting the yearcutoff value to 1910. Not sure what else is going on. ... View more

Here is my result from  proc options option=yearcutoff; run;       SAS (r) Proprietary Software Release 9.4 TS1M5 YEARCUTOFF=1910 Specifies the first year of a 100-year span that is used by date informats and functions to read a two-digit year. ... View more

thanks, any suggestion on how to handle the negative age? ... View more

I had created the b_date variable from the date variable birthdate(with datetime. format) using following code:   birthdate=datepart(b_date); format birthdatef date.;   My data now looks like this after applying the code you suggested. bene_id birthdate b_date date Age   1 18May64:00:06:08 18-May-64 12-Sep-18 54   2 18Jun22:00:09:03 18-Jun-22 12-Sep-18 -4   3 8Sep51:00:01:06 8-Sep-51 12-Sep-18 67   ... View more

Thanks, but I'm still getting -4 as a value for age_exact. ... View more

I used it as: age_exact=floor((intck('month', b_date, Date)-(day(Date) < day(b_date)))/12);   and I saw both two new variables were empty. ... View more