topic do until() issue in SAS Programming

do until() issue

Haikuo — Fri, 30 Mar 2012 17:53:25 GMT

A short while ago, some one asked how to reset the count every time there is a 'N'. So I was thinking if I can reset it every time if there is a CAPITAL character, it turned out not hard to do, as I am going to show you below. However, what I thought would-be equavalent expression seems not equavalent, one working, one not:

Working solution:

data have;

input var1$;

cards;

;

data want (drop=v);

do ct=1 by 1 until (v);

set have;

v=missing(compress(var1,,'u'));

output;

end;

run;

After I switch the contents of 'v' into until(), SAS tells me:

ERROR: Variable var1 has been defined as both character and numeric.

data want;

do ct=1 by 1 until (missing(compress(var1,,'u')));

set have;

output;

end;

run;

Please shed some light on this one and educate me.

Thanks in advance!

Haikuo

do until() issue

art297 — Fri, 30 Mar 2012 18:28:08 GMT

If it makes you feel any better, I don't have any idea why it would behave that way either. My vote is that it is a bug!

do until() issue

Tom — Fri, 30 Mar 2012 18:34:24 GMT

Most likely cause is that in the second step the first reference to VAR1 is in the UNTIL() clause. In the first one the first reference is the SET statement.

I am not sure why SAS assumes var1 is numeric if the first reference to it is in a COMPRESS() function. You would think that would imply a character variable.

do until() issue

Haikuo — Fri, 30 Mar 2012 18:35:36 GMT

LOL. Art, your answer does make me feel better, that is why it is helpful!

Re: do until() issue

Haikuo — Fri, 30 Mar 2012 18:44:52 GMT

Tom,

I would usually agree with you without even blink. But today you have two more questions of mine:

1. Do until() will not be evaluated until the end of the loop, so why does it matter?

2. And please look below, var1 is character and the first encounter happens in until()?

data have;

input var1$;

cards;

;

data want ;

do ct=1 by 1 until (var1='N');

set have;

output;

end;

run;

proc print;run;

Thanks,

Haikuo

Re: do until() issue

Tom — Fri, 30 Mar 2012 19:03:27 GMT

My view is that SAS is actually compiling the data step code. So the first time the COMPILER sees the variable it makes a determination on what type and length to give. Execution order does not matter.

Some times it is obvious. A LENGTH or ATTRIB statement or a reference to an existing dataset in the SET statement.

Next level of easy are simple assignment or comparisons. Your last example is easy for SAS. It sees that you are testing if VAR1 is equal to a character string so VAR1 gets defined as character. The length of the comparison string is known so VAR1 is length 1.

If SAS can't figure it out it defaults to numeric.

Apparently SAS cannot tell that a variable referenced as the first argument to COMPRESS() function should be a string. So it gets defined as a number which conflicts with the definition in the dataset referenced later in the SAS statement.

Re: do until() issue

art297 — Fri, 30 Mar 2012 19:04:33 GMT

Tom is correct, but I still think it is a bug! You can get around it by pre-informing SAS that it really is a character variable. e.g.:

data want;

length var1 $1;

do ct=1 by 1 until (missing(compress(var1,,'u')));

set have;

output;

end;

run;