topic Re: identify rows containing decimals in a numeric column(with out converting in to a character colu in SAS Programming

identify rows containing decimals in a numeric column(with out converting in to a character column)

sahoositaram555 — Wed, 29 Sep 2021 19:34:30 GMT

Hi all,

I have 2 columns such as below.

col1 col2

xxxxx 0.5

yyyyy 1

zzzz 1

kkkk 1

llllllll 1

xxxxx 1.5

yyyyy 2

zzzz 2

kkkk 2

llllllll 2

................. similarly i have values up to 60.

My COL2 is numeric, Looking for a procedure to find out to TAG the rows containing decimal values, the order can not be changed? (with out converting the column in to character and then using any function to pick the decmial)

Re: identify rows containing decimals in a numeric column(with out converting in to a character colu

Reeza — Wed, 29 Sep 2021 19:37:50 GMT

So

decimal = floor(col2) - col2;
if decimal = 0 then .....now what??

Re: identify rows containing decimals in a numeric column(with out converting in to a character colu

PeterClemmensen — Wed, 29 Sep 2021 19:39:36 GMT

I'm not sure I follow. Are you looking to tag/flag non-integers?

Re: identify rows containing decimals in a numeric column(with out converting in to a character colu

ballardw — Wed, 29 Sep 2021 19:40:17 GMT

@sahoositaram555 wrote:

Hi all,

I have 2 columns such as below.

col1 col2

xxxxx 0.5

yyyyy 1

zzzz 1

kkkk 1

llllllll 1

xxxxx 1.5

yyyyy 2

zzzz 2

kkkk 2

llllllll 2

................. similarly i have values up to 60.

My COL2 is numeric, Looking for a procedure to find out to TAG the rows containing decimal values, the order can not be changed? (with out converting the column in to character and then using any function to pick the decmial)

Basic approach is to see if the value when converted to an integer is equal to the original value. If so then there is no decimal, if there is a difference then there is a decimal portion to the value.

data want;
   set have;
   tag = (intz(col2) ne col2);
run;

SAS returns 1 for true and 0 for false. So the comparison above would be 1 when the decimal portion returned by the INTZ function is not equal to the original value.

Re: identify rows containing decimals in a numeric column(with out converting in to a character colu

Peter_C — Wed, 29 Sep 2021 20:44:15 GMT

the logic before programming in code seems to be

if decimal present in col2 then ......

in base SAS code try finding something simpler that

if mod( col2, 1 ) then do;

* ~something ~ ;

end;

Re: identify rows containing decimals in a numeric column(with out converting in to a character colu

Peter_C — Wed, 29 Sep 2021 20:47:23 GMT

perhaps
TAG = ^^mod( col2, 1 ) ;
where TAG should be 1 when there are decimals, and 0 when col2 is integer or missing