FIND AND REPLACE CODE

chirumalla — Fri, 14 Mar 2014 07:37:05 GMT

Hi,

I have developed programs in SAS development here my library name like ABC.dataset but in UAT library name is different like DBA.dataset now i'm manually using ctrl + H and replacing lib name. is any other option/ functions available to find the code and replace the code if I write at starting in the program. pls help me.

Re: FIND AND REPLACE CODE

RW9 — Fri, 14 Mar 2014 09:43:00 GMT

Hi,

If your writing code to run on multiple instances/different parameters then it is probably best to setup your parameters at the beginning of a file (or in separate file) and then reference the macro parameter throughout your code. Saves you have to cntrl+f replace each time. For example:

%let MYLIBNAME = ABC;

...

data &mylibname..newdataset;

set &mylibname..olddataset...

Then when you release to UAT you only need to change the one row %let.

As for find / replace, I don't think there are any other tools within the editor itself which would help. You could create a sas program to read in all the necessary sas files and doa datastep to replace the text with something else, but that sounds overcomplicated and takes time.

topic Re: FIND AND REPLACE CODE in SAS Programming

FIND AND REPLACE CODE

Re: FIND AND REPLACE CODE