topic Help with Macro error in SAS Procedures

Help with Macro error

cypher85 — Tue, 27 Mar 2012 17:44:15 GMT

When I try to run this macro, I get this error. Anyone know how to write the macro to essentially do the same function and have it run successfully?

"ERROR: The macro RENAMES generated CARDS (data lines) for the DATA step, which could cause

incorrect results. The DATA step and the macro will stop executing."

%macro renames(sec);

data &sec ;

input ( original newname) (:$32.);

cards;

Mapped_name Online_Name

B9_ submitdate

run;

%MEND renames;

options mprint;

%renames(renames)

Tom — Tue, 27 Mar 2012 18:07:52 GMT

You cannot use CARDS in a macro. There are tricks using external files and %include to do something like it.

Based on your previous post about the rename macro I would recommend using either

A) Store your list in a permanent dataset that is maintained outside of the macro.

B) Use a FORMAT to do the rename.

proc format ;

value $rename

'B9_' = 'submitdate'

...

;

run;

spjcdc — Tue, 27 Mar 2012 18:10:27 GMT

The simple way to do it is to replace the cards statement with assignment statements and an output statement such as this:

data &sec ;

length original newname $32 ;

original = 'Mapped_Name' ; newname = 'Online_Name' ; output ;

original = 'B9_' ; newname='submitdate' ; output ;

run ;

It sounds like you may have other things that you want to do because what you have here doesn't require a macro.

Steve

cypher85 — Tue, 27 Mar 2012 19:25:51 GMT

Thanks guys, all very helpful!