Hi SAS community, Thank you for looking at my post! I have a question, I have a variable which takes value like this: 1545253657356_EI_1_15_CUP_A 1545253657356_EI_1_15_MUG_A 1545265347356_EI_1_15_BOWL_A 1545T432657356_EI_1_15_CUP_B 15452657356_EI_1_15_MUG_B 1545265237356_EI_1_15_BOWL_B I want to make my variable looks like this CUP_A MUG_A BOWL_A CUP_B MUG_B BOWL_B that is, to delete the non-sense numbers and letters preceding the key words Because I know the key words will take values only in this range: ( CUP_A MUG_A BOWL_A CUP_B MUG_B BOWL_B ) and because the number of non-sense letter/numbers preceding the key words varies, so I don't want to use a substr function, which I have to manually set the position of key words anyone know any SAS function that achieve this using some logic like this extract(variable, from list ( CUP_A MUG_A BOWL_A CUP_B MUG_B BOWL_B )) Thanks in advance!!!
... View more