topic return blank character values in an if statement in New SAS User

return blank character values in an if statement

miajoe — Fri, 08 Mar 2024 12:16:04 GMT

Hi smart people.

I have the following code:

data want;

set have;

if dep="1309825" then dep="" AND source_dep=. AND indexdate_dep=.;

run;

dep is a character value(it can contain letters) and is 11 characters long. SAS returns a 0 rather then a blank when i run this and I want a blank. I have tried:

if scan(dep,1,"1309825")=1 then dep="" AND ... and the rest, but the result is the same.

i Have also tried:

if lenght(dep)=7 and dep="1309825" then dep="" AND ... the rest, also with the same result.....

How can I make it return a blank and not a zero?

thank you

Re: return blank character values in an if statement

miajoe — Fri, 08 Mar 2024 12:26:42 GMT

I solved it. I just wanted to do to much in one go. When i split it up into three seperate if statements and replaced ="" with =" " it worked. So sorry to waste anyones time.

Re: return blank character values in an if statement

PaigeMiller — Fri, 08 Mar 2024 12:34:21 GMT

if dep="1309825" then dep="" AND source_dep=. AND indexdate_dep=.;

You want a blank, not a zero. Normally an assignment statement in a data step looks like this, where variable name is to the left of the equal sign and value assigned to the variable name is to the right of the equal sign. I'm surprised your code works at all, but I have never tried it. Perhaps you want (I'm guessing):

if dep='123456' then do;
    source_dep=. ;
    indexdate_dep=.;
    dep=" ";
end;