topic Re: DO statement not working in SAS Procedures

DO statement not working

spg — Mon, 11 Mar 2013 20:29:24 GMT

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!

Re: DO statement not working

ballardw — Mon, 11 Mar 2013 20:39:05 GMT

Looks like you need an additional array:

array mem mem1-mem7;

and [] instead of () usually

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);

Re: DO statement not working

Ron_MacroMaven — Mon, 11 Mar 2013 21:43:30 GMT

Re: DO statement not working

Tom — Tue, 12 Mar 2013 00:28:29 GMT

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.

Re: DO statement not working

spg — Tue, 12 Mar 2013 14:06:37 GMT

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.