topic Re: Issue with calling result in SAS Programming

Issue with calling result

afs — Sun, 04 Dec 2016 06:56:30 GMT

%macro draft(set1,table1,Lable1);

%if &set1=1 %then %do;

proc freq data=dataset;

set &table1;

run;

%end;

%else %do;

proc means data=sasdata.dataset ;

var &table1;

run;

%end;

%mend draft;

I want to get the macro for each of the variables i.e week and accessories

I should be able to get either freq or means report for above-mentioned variables.My code is below .

But seems i am missing something.can anybody advise?

%macro draft;

%means(dataset,week);

%freq(dataset,accessories);

%mend draft;

Re: Issue with calling result

Kurt_Bremser — Sun, 04 Dec 2016 07:15:58 GMT

Your original macro won't work, because you use &table1 as a dataset in one place and a variable list in another.

Hint: get your steps working without macro code, then replace the future dynamic parts with macro variables, then wrap into a macro definition, and then add macro logic (%if). Test at every step of the development, and thoroughly look at the log. Do a google search for each log message you do not understand.

If you run into obstacles you can't overcome, post test data (data step with datalines) and the log.

Re: Issue with calling result

Cynthia_sas — Sun, 04 Dec 2016 19:00:11 GMT

Hi:

These papers outline the basic process of starting with working code and then converting your code to a Macro program:

http://www2.sas.com/proceedings/sugi28/056-28.pdf

https://support.sas.com/resources/papers/proceedings13/120-2013.pdf

cynthia