How to extract first 3 letters and last letter by using proc sql

[vraj1]

I have a variable which has values like "magnum 1", "magnum 2" "magnum 3". I need to extract first3 and last number like "MAG1"

"MAG2". How can i do this in proc sql?

Any help

[gamotte · Accepted solution]

Hello,

proc sql;
SELECT upcase(cats(substr(x,1,3),substr(x,length(x)-1)))
FROM have;
quit;

[ballardw]

---

@vraj1 wrote:

I have a variable which has values like "magnum 1", "magnum 2" "magnum 3". I need to extract first3 and last number like "MAG1"

"MAG2". How can i do this in proc sql?

Any help

---

Do you have any values with fewer than 4 characters?

If you have "mag" as a value your rule would create "magg".

[vraj1]

Its only 3 letters:-)