topic Re: Simple Question about Integral Values in SAS Procedures

Simple Question about Integral Values

deleted_user — Tue, 06 Oct 2009 15:53:57 GMT

I have a very simple question about case selection in a data step. I wonder what is the command for selecting cases with integral values only, that is, value = 1, 2, 3, ... but I want to exclude the cases with values of 1.5, 2.5, etc. This sounds so simple, something like but I cannot find the proper command. Thanks! Message was edited by: SASLooker

Re: Simple Question about Integral Values

martha_sas — Tue, 06 Oct 2009 18:27:34 GMT

Can you use the mod function? (Since mod(x,1)=0 only if x is an integer). For example, if you want to keep only observations from set 'one' where variable 'x' is integral, you can do this:

data newdata;
set one;
where mod(x,1)=0;
run;

Re: Simple Question about Integral Values

deleted_user — Tue, 06 Oct 2009 20:38:04 GMT

thanks! I'll try that.

Re: Simple Question about Integral Values

ieva — Wed, 07 Oct 2009 10:58:28 GMT

Another simple way how to do that:

data two;
set one;
where x=int(x);
run;

Re: Simple Question about Integral Values

deleted_user — Fri, 09 Oct 2009 15:20:36 GMT

Thanks for the two tips. It appears the mod way works better for my case. The int way also works, but it also includes the blanks or missing values, which I don't want. Thanks for both helpers!