The mainframe does not support the caret symbol ^ (shift 6).
It treats it as an unprintable character.
The caret symbol is used to represent the beginning of a line in the SAS/PERL RegEx.
For example.. the code below says: find 1- in the first position in the line/field.
DAY_FINAL = PRXCHANGE('S/^1-//',1,DAYTIME_PHONE);
Does anyone know how to represent the beginning of the line in a mainframe environment?
Thanks so much for any help.
There must be a way to get the mainframe to accept/transmit a "^" character. Otherwise, you could put a special character at the beginning of the string :
DAY_FINAL = PRXCHANGE('S/@1-//',1,cats("@",DAYTIME_PHONE));
There must be a way to get the mainframe to accept/transmit a "^" character. Otherwise, you could put a special character at the beginning of the string :
DAY_FINAL = PRXCHANGE('S/@1-//',1,cats("@",DAYTIME_PHONE));
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.