topic Re: Nested do loop in sas in SAS Procedures

Nested do loop in sas

munitech4u — Thu, 12 Jun 2014 10:33:48 GMT

This is what i need to do on my dataset:

I have list of variables: p1-p9 and s1-s9. I want to create variables x1-x81 (9*9).

based on if p1=1 and s1=1 then x1=1; else x1 =0;

so on for all p1=1 with s1-s9 and so on for each p1-p9.

How to do this in sas. The manual if else takes so much time. I tried to use nested do loop by using 2 loops 1 for p1-p9 and another for s1-s9. but not working . I think array method will work.

But not sure how to let the nested loop use array of x1-x81.

Suggestions plz?

Thanks!

Re: Nested do loop in sas

LinusH — Thu, 12 Jun 2014 11:15:37 GMT

Why wouldn't an array work? Have you tried?

z=1;

do i=1 to 9;

	do j=1 to 9;
		if p = s then x = 1;
		else x = 0;
		z+1;
	end;

end;

Re: Nested do loop in sas

Ksharp — Thu, 12 Jun 2014 12:20:39 GMT

Or use two dimension array.

array _x{9,9} x1-x81 ;

do i=1 to 9;

	do j=1 to 9;
		if p = s then x[i,j] = 1;
		else x[i,j] = 0;

	end;

end;

Xia Keshan

Message was edited by: xia keshan

Re: Nested do loop in sas

MikeZdeb — Thu, 12 Jun 2014 13:26:11 GMT

Hi ... some other ideas ...

just make all x values 0 to start and just change the p=s x values to 1 ...

array _x{9,9} x1-x81 (81*0);

do i=1 to 9;

do j=1 to 9;

if p = s then _x[i,j] = 1;

end;

or get rid if the IF ...

array _x{9,9} x1-x81;

do i=1 to 9;

do j=1 to 9;

_x(i,j) = p(i) eq s(j);

end;

Re: Nested do loop in sas

Ksharp — Thu, 12 Jun 2014 13:31:17 GMT

So long , Mike !

When are you going to China ?

Xia Keshan

Re: Nested do loop in sas

Reeza — Thu, 12 Jun 2014 14:36:56 GMT

What are the other values of p1/s1. If it's only 1 and 0's you can multiply instead of if/condition.

I think that may be faster.

array _x{9,9} x1-x81;

do i=1 to 9;

do j=1 to 9;

_x(i,j) = p(i) * s(j);

end;

Re: Nested do loop in sas

munitech4u — Thu, 12 Jun 2014 14:50:35 GMT

The condition was if p1=1 and s1=1, they may take other values for which i wanted 0.

This is what I tried unsuccessfully:

data temp;

array p det_lyrica_p1-det_lyrica_p7;

array s det_lyrica_s1-det_lyrica_s7;

array x det_lyrica_p8-det_lyrica_p56;

z=1;

do i=1 to 7;

do j=1 to 7;

if p =1 and s=1 then x = 1;

else x = 0;

z+1;

end;

run;

But it gave just 1 obs and made all p and s as . or missing and put all x=0. I need the variables x to be created for each obs level value.

Re: Nested do loop in sas

Astounding — Thu, 12 Jun 2014 15:03:38 GMT

Do you have an existing data set with data for the P and S variables? If so, there is nothing in your program that brings in that existing data set.

Do you want the program to create a separate observation for every possible combination of the P and S variables? If so, you might have to tell us what values the variables are allowed to take.

Re: Nested do loop in sas

ballardw — Thu, 12 Jun 2014 15:05:51 GMT

You need an OUTPUT statement just before the Z+1;

OR you need to have a SET statement to bring in existing data with the variables in the first two array statements. Without set they are all missing.

Re: Nested do loop in sas

munitech4u — Thu, 12 Jun 2014 15:12:29 GMT

haha... what an error! thanks guys. Its working now, i had forgot to use the set statement.

Re: Nested do loop in sas

MikeZdeb — Thu, 12 Jun 2014 21:28:56 GMT

hi ... maybe this is what you want ...

* make some fake data;

data have;

array det_lyrica_p(7);

array det_lyrica_s(7);

do i=1 to 5;

do j=1 to 7;

det_lyrica_p(j) = ceil(5*ranuni(1234));

det_lyrica_s(j) = ceil(5*ranuni(1234));

end;

output;

end;

drop i j;

run;

proc print data=have;

run;

* add new variables x1-x49 based on the values of det_lyrica_p and det_lyrica_s;

data want;

array p(7) det_lyrica_p1-det_lyrica_p7;

array s(7) det_lyrica_s1-det_lyrica_s7;

* as suggested by KSharp ... array with two dimensions;

array x(7,7) x1-x49;

set have;

do i=1 to 7;

do j=1 to 7;

* logical 1s (condition true) and 0s (condition false)

x(i,j) = p(i) eq 1 and s(j) eq 1;

end;

drop i j;

run;

proc print data=want;

run;

Re: Nested do loop in sas

munitech4u — Fri, 13 Jun 2014 06:05:07 GMT

Thanks for the multiply approach instead of if.