Pull out last two decimals of number

[stancemcgraw]

I have a column for AIS (abbreviation injury score) per patient line of data. Each patient has multiple AISs and the last two digits have spaces between them. I'd like to pull the last two decimals into their own variable columns:

data have: 

studyid            AIS

1                541626 4 4

1                544224 3 4            

2                544222 2 4

2                450203 3 3

data want:

study id         Injury severity    Injury region

1                         4                          4

1                         3                          4

2                         2                          4

2                         3                          3

[ballardw · Accepted solution]

This perhaps?

data want;
   set have;
   
   severity= scan(AIS,2);
   region= scan(AIS,3);
   /* and maybe to have the other value
   stripped of the last two*/
   ais = scan(ais,1);
run;

You have a character value, other wise there could not be spaces embedded. So SCAN will pull pieces separated by spaces (and other delimiting characters as needed).

[Kurt_Bremser]

Use the SCAN() function with -2 and -1.