DATA Step, Macro, Functions and more

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

Reply
Frequent Contributor
Posts: 133

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

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.

Super User
Posts: 19,772

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

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;

Super User
Posts: 10,023

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

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

Ask a Question
Discussion stats
  • 2 replies
  • 270 views
  • 0 likes
  • 3 in conversation