## Hard time getting results while creating a variable of Age in Months

Solved
Occasional Contributor
Posts: 14

# Hard time getting results while creating a variable of Age in Months

Hello,

I am trying to create age in months variable. I tried monthage=intnx('Month', DOB, sampledate) without 12 but I was getting numerical values in the hundred thousands (100,000s). Thus, I tried putting monthage= intnx('Month', DOB, sampledate, 12) because there are 12 months in a year. However, in the out put I got blanks, no errors for either runs. Please see my code below.

```libname mydata "/folders/myshortcuts/myfolder";
run;

Data mydata.temp;
set mydata.blkids2014;
/*Creating age at sampledates variables*/
age1=yrdif(DOB, sampledate,'ACT/ACT');
age2=yrdif(DOB, sampledate2,'ACT/ACT');
age3=yrdif(DOB, sampledate3,'ACT/ACT');
age4=yrdif(DOB, sampledate4,'ACT/ACT');
age5=yrdif(DOB, sampledate5,'ACT/ACT');
age6 =yrdif(DOB, sampledate6,'ACT/ACT');
age7=yrdif(DOB, sampledate7,'ACT/ACT');
age8=yrdif(DOB, sampledate8,'ACT/ACT');
age9=yrdif(DOB, sampledate9,'ACT/ACT');
age10=yrdif(DOB, sampledate10,'ACT/ACT');
age11=yrdif(DOB, sampledate11,'ACT/ACT');
age12=yrdif(DOB, sampledate12,'ACT/ACT');
age13=yrdif(DOB, sampledate13,'ACT/ACT');
age14=yrdif(DOB, sampledate14,'ACT/ACT');
age15=yrdif(DOB, sampledate15,'ACT/ACT');
age16=yrdif(DOB, sampledate16,'ACT/ACT');
/*Creating age in months at sampledates variables*/
monthage1=intnx('Month', DOB, sampledate,12);
monthage2=intnx('Month', DOB, sampledate2,12);
monthage3=intnx('Month', DOB, sampledate3,12);
monthage4=intnx('Month', DOB, sampledate4,12);
monthage5=intnx('Month', DOB, sampledate5,12);
monthage6=intnx('Month', DOB, sampledate6,12);
monthage7=intnx('Month', DOB, sampledate7,12);
monthage8=intnx('Month', DOB, sampledate8,12);
monthage9=intnx('Month', DOB, sampledate9,12);
monthage10=intnx('Month', DOB, sampledate10,12);
monthage11=intnx('Month', DOB, sampledate11,12);
monthage12=intnx('Month', DOB, sampledate12,12);
monthage13=intnx('Month', DOB, sampledate13,12);
monthage14=intnx('Month', DOB, sampledate14,12);
monthage15=intnx('Month', DOB, sampledate15,12);
monthage16=intnx('Month', DOB, sampledate16,12);
run;```

Does anyone have any suggestions on how I can get month age variables (like 73 months, 2 months)?

Thanks,

LMP

Accepted Solutions
Solution
‎03-03-2017 10:29 AM
Occasional Contributor
Posts: 14

## Re: Hard time getting results while creating a variable of Age in Months

I tried intck instead and it worked!

All Replies
Solution
‎03-03-2017 10:29 AM
Occasional Contributor
Posts: 14

## Re: Hard time getting results while creating a variable of Age in Months

I tried intck instead and it worked!

Super User
Posts: 11,343

## Re: Hard time getting results while creating a variable of Age in Months

Please look at this code and see if it matches how you used intck and whether the ages are correct for your purpose.

```data example;
dob= '15JAN2015'd;
do sampledate= '01FEB2015'd, '14FEB2015'd, '15FEB2015'd,'16FEB2015'd,
'01JAN2016'd, '14JAN2016'd, '15JAN2016'd,'16JAN2016'd;
agemonths = intck('Month', dob,sampledate);
put dob= date9. sampledate= date9. agemonths=;
output;
end;
format dob sampledate date9.;
run;```

or did yours look more like:

```data example;
dob= '15JAN2015'd;
do sampledate= '01FEB2015'd, '14FEB2015'd, '15FEB2015'd,'16FEB2015'd,
'01JAN2016'd, '14JAN2016'd, '15JAN2016'd,'16JAN2016'd;
agemonths = intck('Month', dob,sampledate,'continuous');
put dob= date9. sampledate= date9. agemonths=;
output;
end;
format dob sampledate date9.;
run;```

BTW, you need to investigate how to use arrays.

Occasional Contributor
Posts: 14

## Re: Hard time getting results while creating a variable of Age in Months

Hi Ballardw,

I didn't put specific dates because there were a variety of dates. I phrased the statement as follows: monthage=intck('Month', DOB, sampledate);

I hope this helps and/ or answers your question!  Thanks for the tip about arrays! I have tried it before but at the time other variables were deleted or no longer appeared. Basically, I am still working on getting arrays to work right.

All the Best,

LMP

☑ This topic is solved.