topic Pull out last two decimals of number in SAS Programming

Pull out last two decimals of number

stancemcgraw — Wed, 27 Jan 2021 20:09:00 GMT

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

Re: Pull out last two decimals of number

ballardw — Wed, 27 Jan 2021 20:17:53 GMT

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).

Re: Pull out last two decimals of number

Kurt_Bremser — Wed, 27 Jan 2021 20:17:56 GMT

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