topic Adding decimal point to a string variable in SAS Programming

Adding decimal point to a string variable

Tithi — Fri, 02 Feb 2024 18:33:35 GMT

I have ICD-10 codes without decimal points and I would like to add decimal points after the 3rd character.

For example:

I have the following:

F3342

F348

But I would like to have:

F33.42

F34.8

Any help with this will be appreciated! Thank you!

Re: Adding decimal point to a string variable

A_Kh — Fri, 02 Feb 2024 18:43:31 GMT

data have; 
input var $;
cards; 
F3342
F348
;
data want;
	set have; 
	if var ne '' then var= catx('.', substr(var, 1, 3), substr(var, 4)); 
proc print; run;

SUBSTR and CATX functions.

Re: Adding decimal point to a string variable

Tithi — Fri, 02 Feb 2024 19:30:56 GMT

Thank you! This worked.