Hello, i have a colum "CODE" with data like "22A", "3z", "43 G" and so on. Tryed to extract the characters with prxmatch('/[a-zA-Z]/',CODE). It shows me the position but i dont know, what to write in SAS EG that the new column just have the character. Besides i need the same, just for the numbers. So that Code are split in 2 new columns with just the characters and just the numbers. How to archive this in SAS EG? I created 2 new calculated columns and thought with prxmatch('/[a-zA-Z]/',CODE) and prxmatch('/[0-9]/',CODE) i can archive this.
... View more