Hi,
I have a Product(coloumn) in the dataset(test).....which have values like this
product
000112
22431
123456
0
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.
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;
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;
Hi,
Thanks.....It worked....but if i want to send values with 0 into another file. how can i do that?
Thanks,
rk.
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;
Thanks art297......it worked.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.