BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Tithi
Calcite | Level 5

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! 

1 ACCEPTED SOLUTION

Accepted Solutions
A_Kh
Lapis Lazuli | Level 10
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. 

View solution in original post

2 REPLIES 2
A_Kh
Lapis Lazuli | Level 10
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. 

Tithi
Calcite | Level 5

Thank you! This worked. 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 643 views
  • 1 like
  • 2 in conversation