BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
vraj1
Quartz | Level 8

I have a program which has lot of macro calls and i neeed to make a list of existing macro calls in the program.

How can i do that?

 

any help please

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

You would be better off modifying the macros.  Add %PUT statements that write messages about what the macro is going:  beginning execution, creating a data set, ending execution.  That's more reliable, and relatively easy to do.

 

Otherwise, you face many additional complications such as macros that create a data set each time through a loop, macros that call other macros, and extend that idea:  macros that call macros that call macros.

View solution in original post

5 REPLIES 5
Reeza
Super User

You could start by searching the program for all %WORD

 

Then you'll have to filter out all the automatic macros and possibly any use of % in Like comparisons. 

 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

So, you are writing spaghetti code with macro calls all over, and you have no idea of what is in the program - that to me seems to the problem.  Software development in any language is all about the planning and the documentation, design your process, define the inputs/outputs, document the features, create a testing plan.  Then the final 1% of the whole project is writing some code.

 

The alternative, and teh way your going is trying to work out what has happened after the event, which is bound to fail.  Even if you do pull out all the macro calls - and dont forget you would need the paramters to each of those calls and the context of those macro variables - you would need to know the location of the macro file for those (make sure its the correct version), plus resolve conditional logic within those to understand what parts of the macro were used etc.  It can be done, but its a lot of work and is most likely to fail in one way or another.

 

A final note, there is the proc scaproc procedure which is a code analyser:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a003199745.htm

This encompasses your code and produces ouput for inputs/outputs/macros - it may help reduce the amount of work you have to do, however a good and robust SDLC process would more or less eliminate the need for this at all.

vraj1
Quartz | Level 8

Thanks. Basically its a program which creates multiple datasets by macro calls. I can manually pick up the macro calls and make a list but looking for sas code which can pick calls in the program which starts with "%" and list them in a list file

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Well, I can't see the process your doing so can't really say much, however why is the code creating many datasets, which you don't know what they are?  Would it not be better to have one dataset output with a by group separator, or outputs datasets, with a consistent prefix.  Various ways round it.  Again, its all about planning and documentation.  A documented process will show inputs/outputs.

Astounding
PROC Star

You would be better off modifying the macros.  Add %PUT statements that write messages about what the macro is going:  beginning execution, creating a data set, ending execution.  That's more reliable, and relatively easy to do.

 

Otherwise, you face many additional complications such as macros that create a data set each time through a loop, macros that call other macros, and extend that idea:  macros that call macros that call macros.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 2073 views
  • 2 likes
  • 4 in conversation