topic Re: How to extract first 3 letters and last letter by using proc sql in SAS Programming

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

vraj1 — Thu, 08 Mar 2018 10:36:10 GMT

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

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

gamotte — Thu, 08 Mar 2018 10:39:19 GMT

Hello,

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

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

ballardw — Thu, 08 Mar 2018 17:13:21 GMT

@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".

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

vraj1 — Fri, 09 Mar 2018 07:06:37 GMT

Its only 3 letters:-)