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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.