topic Re: Select data with only 4 decimals in SAS Programming

Select data with only 4 decimals

podarum — Mon, 05 Oct 2020 15:58:03 GMT

Hi, I have a dataset that is interest rate, most of the data is in a 2 decimal format (eg. 2.45), but some rows have a 4 decimals (eg. 2.4678) format. How do I chose the data that has only the 4 decimals? Thanks

Re: Select data with only 4 decimals

novinosrin — Mon, 05 Oct 2020 16:17:30 GMT


data have;
 k=2.4678;
 output;
 k=2.34;
 output;
 k=2;
 output;
 k=2.4450;
 output;
 k=2.4400;
run;

data want;
 set have;
 if mod(k*1e4,10);
run;

/*or where*/

 where mod(k*1e4,10);

Re: Select data with only 4 decimals

Tom — Mon, 05 Oct 2020 16:17:18 GMT

@podarum wrote:

Hi, I have a dataset that is interest rate, most of the data is in a 2 decimal format (eg. 2.45), but some rows have a 4 decimals (eg. 2.4678) format. How do I chose the data that has only the 4 decimals? Thanks

If the field is not a character string then you don't.

How can you tell the difference between a value that was original written as '2.50' and a value written as '2.500'? They are the same number.

Re: Select data with only 4 decimals

PaigeMiller — Mon, 05 Oct 2020 16:23:00 GMT

The solution from @novinosrin fails if k=2.46789.

How about this:

data want;
	set have;
	ychar=put(k,best12.);
	if length(strip(scan(ychar,2,'.')))=4;
run;

And @Tom makes a good point too...

Re: Select data with only 4 decimals

novinosrin — Mon, 05 Oct 2020 16:43:46 GMT

Yes, that's correct. The solution assumes based upon OP wrote "most of the data is in a 2 decimal format (eg. 2.45), but some rows have a 4 decimals (eg. 2.4678) format."

Re: Select data with only 4 decimals

Reeza — Mon, 05 Oct 2020 16:46:39 GMT

What's your original data source? Can you read it in as character first?
This would solve your problem, technically....you may still have logic issues.

Re: Select data with only 4 decimals

podarum — Mon, 05 Oct 2020 17:10:02 GMT

Thanks everyone, the answers are great

Re: Select data with only 4 decimals

ChrisNZ — Tue, 06 Oct 2020 01:25:58 GMT

Another way:

 if length( scan( put(VAR,best32. -l), 2, '. ' ) ) = 4;