topic loop in SAS Programming

loop

deleted_user — Thu, 20 Nov 2008 08:06:30 GMT

I want to convert following sorted data set to:

VAR1 VAR1 VAR2
laden laden 1
tussen tussen 1
lossen lossen 1
laden ===>> laden 2
tussen tussen 2
lossen lossen 2
lossen lossen 2
laden laden 3
lossen lossen 3

where a VAR2 is a variable that is a new cycle each time VAR1 is 'laden'.

which code do I need for this conversion?

Re: loop

deleted_user — Thu, 20 Nov 2008 10:24:42 GMT

Is this what you are after?

data after;
set before;
*if var1 is laden add one to the new variable;
*this syntax will automatically retain the value of var2;
*and will not give you a missing value if the value of var2 is missing;
if var1='laden' then var2+1;
run;

I haven't run this but it should work. forgot to put quotes round the literal. Done now.

Message was edited by: pznew

Re: loop

LinusH — Thu, 20 Nov 2008 12:50:14 GMT

For this construct you need to have VAR2 retained between observations:

data after;
set before;
retain var2 0;
if var1 eq 'laden' then var2+1;
run;

/Linus

Re: loop

deleted_user — Thu, 20 Nov 2008 15:09:52 GMT

As I mention in the code comment. The sum statement will automatically retain the variable. You can put the retain in for completeness but it is not required.

P