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
Hello,
proc sql;
SELECT upcase(cats(substr(x,1,3),substr(x,length(x)-1)))
FROM have;
quit;
Hello,
proc sql;
SELECT upcase(cats(substr(x,1,3),substr(x,length(x)-1)))
FROM have;
quit;
@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".
Its only 3 letters:-)
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.