DATA Step, Macro, Functions and more

Equivalent to VBA step mode?

Reply
Contributor
Posts: 27

Equivalent to VBA step mode?

I'll premise by saying I am a very new SAS user.

Today I needed to debug some logic statements. Ordinarily in VBA I would execute the code in step mode (F8), and be able to see which statements/variables/calculations would be tripping me up. Is there any equivalent to this in SAS? If not, how would you recommend debugging long logic statements?

Thanks

Super User
Posts: 17,745

Re: Equivalent to VBA step mode?

http://www2.sas.com/proceedings/sugi25/25/btu/25p052.pdf

Or you can end your program in certain places  (Add run early) and/or add put statements in relevant locations to see the status of variables through the data step.

You can also post here Smiley Happy

Super User
Posts: 5,071

Re: Equivalent to VBA step mode?

rwnj,

Another quick and dirty method is to add this statement just before your DATA step:

options obs=0;

However, you might want to make sure that you won't destroy any permanent SAS data sets by replacing them with 0 observations.

Also, you have to realize that debugging tricky logic means more than getting rid of the error messages.  Even without error messages, there is the question of whether the logic does the right thing.  You may need to devise some data that will test what you expect the logic to do.

Good luck.

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