"Speak of the SAS genie", I was just mentioning to a mate that you will come up with a proc tabulate and you did. 🙂 Kudos to me for predicting haha and you lol ... View more

Keep it simple:   data have; input string $12.; cards; abc limited pqr ltd limited abc abc sa abc plc plc abc abc inc ; data want; set have; want = prxchange("s/\s*\b(inc|limited|ltd|sa|plc)\s*$//io", 1, string); run; ... View more

Assuming you are just updating value sourcing from Table A, you could use dataset option to keep id and value alone   data b; modify b a(keep=id value);/*drop the rest*/ by id; if _IORC_=0 then replace; else _ERROR_=0; run; ... View more

You could put a filepath on your ODS LISTING. ods listing file='/folders/myfolders/demo.txt'; proc compare .... run; ods listing close; ... View more

the 'i' modifier in the findw function ignores the case.   data want; set have; if findw(varname,'and',' ','i'); run; ... View more

For an increase in speed, try the following which uses lazy repetition factors (i.e. \s*?)   data test; length var1 $ 100            var2 $ 100; var1=' // / /ab c / d e f /g hij/ //kl m/ / '; var2=prxchange('s/\s*?(\/)\s*?(?!\s)/$1/', -1, var1); run; ... View more

@SASPhile wrote: a worksheet say master.xls has five sheets : credit,debit,mortgage,escrow,insuarance. Instead of giving the sheet names in a macro variable, is there a way for SAS to create 5 datasets for master.xls? Yes, but it depends on how your data is stored.  You really need to add some details if you want anything beyond yes it's possible.    ... View more

There are more updates on the enahanement are coming.I havent tested it yet, will let you know if it worked. Thanks for your followup.   ... View more

@FreelanceReinh Yup, that would help 🙂 ... View more

@SASPhile wrote: 1. How to know what processes are running? 2. How to kill the processes on windows? If you want to make your life easier, can the toybox and switch to a real operating system. At the moment, this means UNIX.   I work on a UNIX platform, and on such this is a non-issue, as I can easily remove links to files (aka "directory entries") from the filesystem while a process is still using the file. That is because UNIX systems have a different concept of filesystem structure that is lightyears ahead of the much-too-simple method that Windows has. ... View more

Hi @SASPhile,   I've just created a keyboard macro (for the SAS Enhanced Editor) which seems to do what you want, but it's rather a risky workaround (with limitations) than a clean solution.   The major limitation is: Your code must not contain both curly braces {} and square brackets [].   Let's assume it doesn't contain curly braces (then it may contain square brackets).   I recorded a keyboard macro (Enhanced Editor: Tools --> Keyboard Macros --> Record New Macro) which replaces %do ("Match whole word only") with { and %end with } ("Replace All") and vice versa (so as to restore the original code). Then I stopped recording, edited the macro (Tools --> Keyboard Macros --> Macros... --> Edit...) to insert the command "Move cursor to matching brace/paren" in the middle between the replacement actions and assigned a shortcut key to the macro.   Now, when I place the cursor on the percent sign of a %do or %end keyword and press the shortcut key, the cursor jumps to the percent sign of the matching %end or %do, respectively (and back if I press the shortcut key again).   Obviously, I haven't tested this macro thoroughly yet and I wouldn't really recommend it.   Given that there is an Enhanced Editor command to find matching DO/END pairs in a data step, it's a pity that there is no similar feature for %DO/%END.   ... View more