I would make sense but ... it can't   See Solved: Regular expression search and replace in SAS EG is broken - SAS Support Communities ... View more

Assuming you mean Find/Replace in SAS EG's editor or a similar SAS-based program editor, the short answer is ... no ! See Solved: Regular expression search and replace in SAS EG is broken - SAS Support Communities Contrary to the title, it is not "solved". Comments added by a SAS employee on that Thread confirm SAS EG does not have this functionality in the Replace even though it can be used in the Find In simple terms what you're asking is ... can you (for example): Find: (.*)_date Replace: date_\1 and clicking Replace (or Replace All) with Match whole word on and regular expression turned on (this should flip "date" as a prefix instead of a suffix) ? But this does not work in SAS EG, whereas it will work in Notepad++ (which is where I end up doing these sorts of reg-exp changes). On the flip side: Find: (.*)_date clicking Find (not Replace) will work, finding words that have _date as a suffix. ... View more

You don't need to learn any non-SAS skills, like regular expressions, to solve this and you don't need reams of code. The easiest way to deal with the endings of strings is to use reverse with strip (or trim) and the eventual solution code will need less conditions/statements. The "sample" input includes 00000 (mentioned in another reply). data test; input textchar : $5.; cards; 00000 00100 00101 01010 10100 10101 ; run; data want; set test; length want $5; want=textchar; do while (substr(strip(reverse(want)),1,1) eq "0"); want=strip(reverse(substr(strip(reverse(want)),2))); end; run; proc print;run; The result is: Obs textchar want 1 00000   2 00100 001 3 00101 00101 4 01010 0101 5 10100 101 6 10101 10101 Note: This is a solution based on my interpretation of the requirement.     The alternative "do" loop construct (still based on the above): do until (substr(strip(reverse(want)),1,1) ne "0"); does not work - observations 3 and 6 are incorrect: Obs textchar want 1 00000   2 00100 001 3 00101 00101 4 01010 0101 5 10100 101 6 10101 10101   ... View more

This is the solution I used - the full path can be put in the quotes without any limits. ... View more

@Tom syntax error in the code - should be "PROC CONTENTS ..."   proc contents data=HAVE out=contents noprint; run; proc sql noprint; select name into :datevar separated by ' ' from contents where 'date'=fmtinfo(format,'cat') ; %let ndates=&sqlobs; quit; ... View more

The solution provided only works when the relevant "engine" (in this case XLSX) is installed on the SAS server. ... View more

SAS filenames aren't always decided upon by the SAS coder. I work in an installation where specific files need to put in a specific folder/path structure in a specific place. I just had this exact issue (hamstrung by 201 characters) last week and had to play around with the base filename (i.e. the name after the last /), plus I have 10 files in total, due to a macro loop - I've succeeded with 9 but struggling to get the 10th one shortened, which I will solve, somehow. Aside from this trivial issue, the point at the start of this response needs to be considered before dismissing comments in such a way, i.e. "Can you remember those and type the names." I don't need to type the names - I have shortcuts in Windows to the locations where my files will reside or a few folder levels higher. ... View more

Scroll bar appearance in Windows applications can be defaulted to the O/S settings or can be controlled by the application software's author. In my case, all windows applications in Windows 10 Enterprise on my company's laptop and Windows 10 in the Citrix client connected remotely to the Customer site (that I'm doing work for) appear with 'normal' width scroll bars. However, in SAS EG [8.2 Update 4 (8.2.4.1261) (32-bit)] on both my laptop and in the Citrix window, the scroll bars are super skinny.   This is a SAS EG issue, pure and simple, and currently there is no setting in the SAS EG's Options that would remedy the skinny scroll bars. ... View more