topic Re: modifying sas codes or sas files using anonther sas file in New SAS User

modifying sas codes or sas files using anonther sas file

nathilanga — Mon, 08 Apr 2019 13:08:29 GMT

Good day

have a list 20 of programs

Sales.sas

Marketing.sas

HR.sas

all these they have a common macro variable called currentReporingmonth i want to iterate through all of them to find and replace that variable with mon1_date9 and output another sas code with chagnes or file for example

Sales.sas -> Sales1.sas

Marketing.sas -> Marketing1.sas

HR.sas -> HR1.sas

Your help will be highly appreciated

Regards

Re: modifying sas codes or sas files using anonther sas file

AMSAS — Mon, 08 Apr 2019 14:06:22 GMT

Hi nathilanga,

You could write some Base SAS code to do this, but for 20 files, it would probably be simpler to do it manually.

If you are going to be doing this on a regular basis, and want to write some SAS code to do it, then I'd approach it as follows

Determine the files to be updated (External File Functions)
Read each file into SAS (Working with External Files)
Do the replace (Character String Matching Functions)
Save each file with a new file name (Working with External Files)

Re: modifying sas codes or sas files using anonther sas file

ballardw — Mon, 08 Apr 2019 14:34:39 GMT

Why change the code? Do you assign a value to the macro variable in each file? If that is the case then a likely better approach would be to remove the assignment code an do that in a separate program that then calls the program files with %include statements.

Since you don't actually provide the 1) current macro variable name, 2) how that particular macro variable is used, 3) what you explicitly want the macro variable changed to and 4) source code of at least one of those files, it is very hard to provide any actual concrete code.

And things may get more complicated if any of your program files define or call macros.

Re: modifying sas codes or sas files using anonther sas file

Kurt_Bremser — Mon, 08 Apr 2019 15:18:56 GMT

A proper operating system (read: UNIX) provides a great tool for such text operations, it's called awk.

Re: modifying sas codes or sas files using anonther sas file

andreas_lds — Tue, 09 Apr 2019 09:12:52 GMT

@Kurt_Bremser wrote:

A proper operating system (read: UNIX) provides a great tool for such text operations, it's called awk.

And Windoze has Powershell for the same job but i would use a text-editor allowing find+replace on multiple files in a folder, e.g. Notepad++.

Re: modifying sas codes or sas files using anonther sas file

nathilanga — Tue, 09 Apr 2019 12:52:43 GMT

Good day

i am still investigating its some thing that has to do with pipe and xcom in sas

Re: modifying sas codes or sas files using anonther sas file

nathilanga — Tue, 09 Apr 2019 12:54:18 GMT

Good day

reason for the code change is to standardize it, i have plenty of code that needs to change

so that everyone can use one auto exec for libraries and dates