DO statement not working

[spg]

Hi,

I'm trying to write a code that will calculate ages of all members of a family (MEM1 to MEM7) from their dob. My data looks like this

FAMILY	MEM1	MEM2	MEM3	MEM4	MEM5	MEM6	MEM7
001	2/1/1941	9/1/2000	2/1/2004	.	.	.	.
002	6/1/1989	.	.	.	.	.	.
003	8/1/1963	8/1/1963	.	.	.	.	.
004	9/1/1994	6/1/2000	.	.	.	.	.

When I run the following code, it says MEMi variable is uninitialized. Please help.

data a;

set b ;

array age {7} age1-age7;

array age_mem {7} age_mem1-age_mem7;

do i=1 to 7;

age(i)=floor( (intck('month', MEM(i), '01jan2013'd) -(day('01jan2013'd) < day(MEM(i))))/12);

age_mem(i)= age(i)-(floor( (intck('month', MEM(i), '01jan2013'd) -(day('01jan2013'd) < min(day(MEM(i)), day(intnx('month','01jan2013'd,1) -1)))/12)));

output;

end;

run;

Thanks!

[ballardw]

Looks like you need an additional array:

array mem mem1-mem7;

and [] instead of () usually

so

age(i)=floor( (intck('month', MEM, '01jan2013'd) -(day('01jan2013'd) < day(MEM(i))))/12);

should be

age=floor( (intck('month', MEM, '01jan2013'd) -(day('01jan2013'd) < day(MEM)))/12);

[Ron_MacroMaven]

see also:

http://www.sascommunity.org/wiki/Tips:Calculating_Exact_Age_with_the_YRDIF_Function

Ron Fehd  sasComm.org maven

[Tom]

The error message is because the name of the array was AGE_MEM and not MEM.

Look at this thread for how to calculate age. 

Also you probably do not want the OUTPUT statement.  Unless you also want to rotate the data into a vertical format.

[spg]

Hey! Thanks for the tips on the age calculation facility in SAS 9.3. I do have that version and will make use of it towards this end.

Thanks again, all. I alsofixed the code to make it run now.