topic Re: some refactoring tool that traverse through SAS SQL/Macro Data Steps? in SAS Programming

some refactoring tool that traverse through SAS SQL/Macro Data Steps?

ZRick — Wed, 15 Aug 2012 21:23:18 GMT

I need some software that does refactoring job across sas sql/macro/ iml data steps to realize:

1. highlight related variable in all related sas code.

2. change one variable and change all related variables in all related sas codes.

for instance, variable $chr, it appears in proc sql 2 times, macro 3 times, data step 1 time

I need tool to highlight $chr in all related code

I need to change one place and change all other places.

I need to measure the change in terms the performance, stability, etc.

Re: some refactoring tool that traverse through SAS SQL/Macro Data Steps?

Reeza — Wed, 15 Aug 2012 21:34:48 GMT

Why are you changing the variable name?

Is it because you're re-running the code to apply to different variables? Or is it code maintenance?

You can consider looking at macro variables that you set at the beginning and then change in one place instead of replace everytime.

%let my_var=age;

proc means data=sashelp.class;

var &my_var;

run;

proc freq data=sashelp.class;

table &my_var/missing;

run;

Re: some refactoring tool that traverse through SAS SQL/Macro Data Steps?

Ksharp — Thu, 16 Aug 2012 03:28:59 GMT

SAS is not a IDE tool like Eclipse or Netbeans . I am afraid it is too hard for sas .But you can use menu EDIT->REPLACE to replace the variable name , also you can use data step to processs the sas code(sas code is a txt file). But it is also limited for refactoring .

Ksharp