Hi:
This question, in various forms, has been asked and answered several times in several different forums.
1) First have a working SAS program that produces each report you want.
2) Then, instead of hard-coded values use macro variables to test that you have covered all the possible macro variables that you could possibly need
3) Possibly use a macro program to introduce %IF/%ELSE conditions into your macro program so that correct code gets generated based on the presence or absence of macro variables that are passed to the macro program when it executes.
4) Test the macro program in #3 with ALL the combinatioins of macro variables
5) Then, modify your code to use %STPBEGIN/%STPEND and introduce %GLOBAL statement for all the macro variables that will come from prompts defined in the metadata.
6) Register the stored process in the metadata and set the prompt definitions (this is necessary so that each client application shows the user a popup window to make choices)
7) Test the stored process in all the client applications where it will be requested.
I generally recommend that you do steps 1,2,3 and 4 outside of a stored process environment. I know that I have posted many different code examples that show just about everything that needs to be done:
http://communities.sas.com/message/117373#117373
http://communities.sas.com/message/115182#115182
Prompts that are created in the prompting interface for a stored process come to your program as SAS GLOBAL MACRO VARIABLES. So if you understand how to use macro variables in your code, then you will be able to easily create a prompt in a stored process.
As I explained before, the steps to register a prompt are lengthy and well documented in the many user group papers and the Stored Process Developers. The place to start is to take a program like this:
%macro ckage;
%if &age GE 17 or &age le 10 %then %do;
data errmsg;
errmsg = 'Age can only be between 11 and 16';
output;
errmsg = "You specified an age value of &age";
output;
run;
proc print data=errmsg noobs;
var errmsg / style(data)={foreground=red font_size=20pt};
run;
%end;
%else %if &age lt 17 %then %do;
proc print data=sashelp.class;
title "Showing age &age and for &gender students";
where age=&AGE and sex = "&gender";
run;
%end;
%mend ckage;
*ProcessBody;
%stpbegin;
%ckage;
%stpend;
(previously posted code}
Save this file as XXX.SAS on your system and then create a stored process from XXX.SAS. You can either use SAS Management Console or use SAS Enterprise Guide to register the stored process and define the prompts. The macro variables that will become prompts are those used in the code... so you will have a prompt for AGE and another prompt for GENDER. You should probably add a %GLOBAL statement above the *ProcessBody; line:
%GLOBAL AGE GENDER;
Then, after you register this stored process, you will have to test it. If you define the prompts correctly, you should see a popup window with a prompt for AGE and a prompt for GENDER.
If you continue to need help with defining a stored process or adapting your code, then the appropriate thing to do is to open a track with SAS Tech Support. They will likely ask you for a copy of the working SAS program that you want to convert to a stored process -- so you should attempt steps 1, 2 and 3 -- outside of the stored process world -- before you attempt to write a stored process. Since 1, 2 and 3 steps all involve writing code and using macro variables and writing and using macro programs, learning how macro programs work would be a good place to start. I always recommend this paper as a good introduction into how macro variables and macro programs work.
http://www2.sas.com/proceedings/sugi28/056-28.pdf
Good luck!
cynthia
