As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

Difference between revisions of "Tips:Reg Exp Substitution in Proc Format"

From sasCommunity
Jump to: navigation, search
Line 22: Line 22:
[[Category:Tip to be Reviewed]]
[[Category:Tip to be Reviewed]]
[[Category:Tip Awaiting Refinement]]

Revision as of 20:07, 23 May 2014

Did you know that PROC FORMAT in 9.3 allows regular expressions in INFORMAT and (user-written) function calls in FORMAT? You can even do the reg exp substitutions! Let's try something fun. Read Rick's SGF2012 paper and try to complete the chain reaction. Good luck!

proc format;
   invalue $final 's/final/four/' (regexpe) = [$four.];
   invalue $four  's/four/square/' (regexpe) = [$square.];
   invalue $square 's/square/dance/' (regexpe) = [$dance.];
   /* your code here */
   invalue $travel 's/travel/guide/' (regexpe) = _same_;
run; quit;
data _null_;
   var = input("final", $final.);
   put var=;
/* on log
Submitted By chang_y_chung