topic Re: MACRO Broken in SAS Programming

MACRO Broken

Juli13 — Fri, 27 Oct 2017 14:05:05 GMT

options mprint mlogic;

%macro type(data);

data &data;

set astc.&data;

year=input(data_yr);

run;

%mend type;

%type (ppa_astc_cms1500_2013);

Re: MACRO Broken

ballardw — Fri, 27 Oct 2017 14:19:24 GMT

Please provide exactly what happens that makes you think the macro is broken.

And paste the result of the Log into a code box opened using the forum {I} menu icon. It is important to paste into a code box as the message window reformats some of the error and warning messages and those often provide something that points to offending code errors.

The Input function wants an informat to apply when attempting to do what ever to the variable data_yr so you should have gotten an error.

Other possible problems may exist but we need to see the log for that.

Re: MACRO Broken

Astounding — Fri, 27 Oct 2017 14:29:47 GMT

MACRO language isn't broken Rather, your SAS language program is broken. The INPUT function requires two arguments, and you have only supplied one. It is best to follow the usual rule: Get the program working without any macro language, and then turn the working code into a macro.

Re: MACRO Broken

Kurt_Bremser — Fri, 27 Oct 2017 15:24:12 GMT

The only thing broken is your data step coding skills, as others have already mentioned 😉

Since no SAS/STAT procedures are involved, I moved this thread to Base SAS Programming, where it belongs.