topic delete zero value from character field in SAS Programming

delete zero value from character field

sasg — Mon, 25 Jul 2011 21:13:49 GMT

Hi,

I have a Product(coloumn) in the dataset(test).....which have values like this

product

000112

22431

123456

03456

I would like to delete row contains 0 value....how could i do that,is there any function?

output should be like this

product

000112

22431

123456

03456

Thanks,

rk.

delete zero value from character field

art297 — Mon, 25 Jul 2011 21:32:29 GMT

There are a number or ways and it will depend upon the type of field, etc. I'm going to guess that it is a character field and you can get away with something as simple as:

data want;

set have (where=(strip(product) ne "0"));

run;

delete zero value from character field

sasg — Mon, 25 Jul 2011 21:55:39 GMT

Hi,

Thanks.....It worked....but if i want to send values with 0 into another file. how can i do that?

Thanks,

rk.

delete zero value from character field

art297 — Mon, 25 Jul 2011 22:06:05 GMT

Since you've already run what you want, you can do the other the same way:

data dontwant;

set have (where=(strip(product) eq "0"));

run;

Of course, if you wanted to do it all in one step:

data want dontwant;

set have;

if strip(product) eq "0" then output dontwant;

else output want;

run;

delete zero value from character field

sasg — Mon, 25 Jul 2011 23:16:05 GMT

Thanks art297......it worked.