How to create a simple Panel to execute a query in SAS

[Mike_Davis]

Hello All

How to create a simple panel(like a GUI) with input area and button to assign parameters ,then after input the dataset's name('sashelp.class') and sex("F") then after push the button,we can do the follow things:

1,print sashelp.class to output

2 only print where sex='F'

what means after we input the parameter and push the button we can do the same things as run the SAS code below:

proc print data=sashelp.class;

where sex='F';

run;

Thanks!

[Ksharp]

Are you using SAS/EG ?

EG has some such capability by using prompt manager tool, which is actually some macro variables manager tool.

And That is good if you are familiar with SAS/AF ,It looks like the best way for you situation .

Ksharp

[Patrick]

For EG4.2

http://support.sas.com/resources/papers/proceedings10/041-2010.pdf

For "PC SAS"

http://support.sas.com/kb/39/007.html

IMS

http://support.sas.com/kb/41/059.html

Use keywords "SAS prompt framework" and I'm sure you'll find a solution for your situation.