Replace in file, universal solution.

[jakarman]

As you are switching from Windows to Unix there are some attention points.

Desktop portable Windows tools, evaluate:

- Terminal usage, yes like the old mainframe days, for the shell access something like putty and being graphical a X-server (moba xterm 9.4)

- Upload/download to Windows, sftp/ftp, winscp and notepad++ with add-ons. (compare/replace)

Data conventions, get accustomed to:

-  the LF (Unix) and CR/LF Windows record difference. With binary transfers it could get mixed up in the wrong way.
- Latin1 wlatin1 differences in the encoding (single byte) and the utf8 (multiple byte) Excel Word and Html are already using utf8.
  Most people still working/thinking in wlatin1.

  I expect you are getting EGuide delivered with the promise nothing will really change to you. (yeah..... forget that).

Support for your SAS usage.
You may be classified as a very dangerous person for the company using VBA and Windows scripting.
They may possible try to lock you out from all of that. You are needing a guy as platform-admin that will really will try to help you.
The first hurdle is the default setting of noxcmd for all SAS services,  not allowing you to access Unix.    

[Yura2301]

Hi again Jaap,

All tasks that I made using VBA scripts wasn't related to business data etc., it was usually one time event tasks for achiving some local goals and couldn't really demage anything, plus offcource I didn't execute any vbs on production:), only development environmant.

For some tasks I also used Perl just becouse it really good in parsing stuff etc.

Thanks!

[jakarman]

That is nice, you are not a newbie. It looks you have not got locked out, also nice.
For Perl, did you use Prxparse? SAS(R) 9.4 Functions and CALL Routines: Reference, Second Edition
It is Perl string parsing stuff called from SAS

[Yura2301]

Hi Jaap,

Yep, I used couple of SAS function that support regular expressions - PRXChange etc.

On big strings it works fuster then SAS functions for working with characters.

Thanks!