topic Re: SAS Macros to Run Different Datasets in Developers

SAS Macros to Run Different Datasets

ruzvmun — Wed, 30 Aug 2017 20:09:04 GMT

Hi all,

I am trying to create a Web Stored Process that uses a single sourcefile to create different reports.

I would imagine I'd need different Macros for each datastep, like below.

libname sourcefile 'SingleSourceFile';

run;

data &one;

set sourcefile;

where b=1;

run;

data &two;

set sourcefile;

where b=2;

run;

data &three;

set sourcefile;

where b=3;

run;

The Stored Process will ask user to select report to run and point and run a datastep based on what the Macro Varible.

If possible, can someone point me to any resouce that I can use to create this solution.

Thanks for your help all.

Ruzvmun

Re: SAS Macros to Run Different Datasets

Tom — Wed, 30 Aug 2017 21:14:30 GMT

I don't understand the question. If you want a single program to generate multiple reports why not just code the program to generate multiple reports?

Are you asking how to make the program conditionally generate only some of the reports based on the user's choice?

Re: SAS Macros to Run Different Datasets

ruzvmun — Thu, 31 Aug 2017 12:24:49 GMT

Hi Tom,

Yes...based on prompt user selects, run specific data step and leave out the rest. Does that make sense.

I apologize for the confustion, still a SAS novice.

Re: SAS Macros to Run Different Datasets

FredrikE — Fri, 01 Sep 2017 08:12:55 GMT

You might want to use a macro statement that checks what the user want and then select which report to create?!

Lets say you have a prompt called reportSelection and it contains two reports -R1 and R2.

As an example STP code could look something like:

%macro select_report();

%if &reportSelection = R1 %then %do;

data out;

set sourcefile;

where b = 1;

run;

proc tabulate data=out;

......

.....

run;

%end;

%if &reportSelection = R2 %then %do;

data out;

set sourcefile;

where b = 2;

run;

proc print data=out;

run;

%end;

%mend;

%select_report;

Two different data selections and different outputs 🙂

//fredrik

Re: SAS Macros to Run Different Datasets

ruzvmun — Fri, 01 Sep 2017 13:14:39 GMT

Thank you Fred,

this worked and now I Boss is happy:)