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:-)
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.