topic Re: Trouble with macro that converts datasets into datasteps in SAS Programming

Trouble with macro that converts datasets into datasteps

byeh2017 — Wed, 15 Mar 2017 11:51:51 GMT

I'm trying to convert a sample dataset and its been giving me this error. Not quite sure what I typed wrong:

 
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 WARNING: Apparent invocation of macro DATA2DATASTEP not resolved.
 61         
 62         %data2datastep(samplemonthanalysis,mydata,,100);
            _
            180
 
 ERROR 180-322: Statement is not valid or it is used out of proper order.
 
 63         
 64         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 77

Re: Trouble with macro that converts datasets into datasteps

RW9 — Wed, 15 Mar 2017 12:11:42 GMT

That error is telling you that the macro is never defined. You either need to have it in code before the call (i.e. a %macro ... %mend; before the code) or %include "..."; another file which does contain that macro definition - again, before you try to use it.

Re: Trouble with macro that converts datasets into datasteps

Astounding — Wed, 15 Mar 2017 13:15:13 GMT

Do you know where the file data2datastep.sas is stored?

Here are a couple of additional possibilities for what went wrong.

Should your program contain an OPTIONS SASAUTOS= statement that was inadvertently omitted?

Did your EG session try to work with other macros that were not found, before encountering this error? (This situation can be overcome by just starting a new EG session.)

Re: Trouble with macro that converts datasets into datasteps

Kurt_Bremser — Wed, 15 Mar 2017 13:28:27 GMT

Just repeat the steps you succesfully used when we solved https://communities.sas.com/t5/Base-SAS-Programming/Filtering-out-entries-that-do-not-have-a-certain-scheme/td-p/340374

Re: Trouble with macro that converts datasets into datasteps

byeh2017 — Thu, 16 Mar 2017 08:33:11 GMT

It seems that a simple reloading of a new session helped with it. Thanks!