topic adding period in SAS Programming

adding period

archibald — Mon, 21 Nov 2016 21:21:29 GMT

hello,

I have this data and need to to add a period to the ID variable to get to this result "data want"

Any thoughts? thank you.

data have;

Id;

datalines

40300

Z01

U900

303037

Z110112

917

3039

L303936

U30501

R00

305

U307G7

;

data want

403

Z01

U90.0

303.037

Z11.0112

917

303.9

L30.3936

U30.501

R00

305

U30.7G7

Re: adding period

Shmuel — Mon, 21 Nov 2016 21:39:33 GMT

What is the logic (rules) for adding the period ?

Is it adding after the 3rd character in case of more than 3 characters ?

then:

data want;

set have;

if length(strip(ID)) > 3 then

ID = catx('.', substr(ID,1,3) , substr(ID,4));

run;

Re: adding period

ChrisNZ — Tue, 22 Nov 2016 01:59:16 GMT

Or even:

data WANT;
set HAVE;
ID = catx('.', substr(ID,1,3) , substr(ID,4));
run;

Re: adding period

archibald — Tue, 22 Nov 2016 15:29:55 GMT

This is absolutely perfect! Thank you very much!

Re: adding period

archibald — Tue, 22 Nov 2016 15:32:11 GMT

Another great solution. Thank you!!