Date:         Tue, 22 Jun 2004 23:48:17 -0600
Reply-To:     Alan Churchill <EmailMeDirectly@ThisWebSite-erratix.us>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <EmailMeDirectly@THISWEBSITE-ERRATIX.US>
Subject:      Re: Looking for general ideas on how to approach a user interface
              sel              ection process

I would suggest building a user front-end tool on a web site and then
allowing users to choose from dropdown lists populated by the unique values
available. Then fire the SAS query and return the results to a website
(list, datagrid, etc). The user could then choose to download the list to
excel, csv, xml, etc. A simple button control can allow the user to select
the choice and it can be sent via email, etc.

If you need suggestions on how to approach, please let me know.


--
Alan Churchill

Savian
"Bridging SAS and Microsoft technologies"
(719) 687-5954

"David Fickbohm" <DavidF@HOMEGAIN.COM> wrote in message
news:09E1FB011D56C7499296BC687D4A0AAD0D5B1FE9@hqsxch01.homegain.com...
> People,
> I am working in PC SAS version 8.1 in a windows environment.
>
> I have three SAS files.
>
> The first of 39,092 records consists of zipcode, state, city, county,
> areacode, msa_id, fips, population, and a field indicating whether there
is
> another city with same name in the file.
> The second and third files consist of 93 records each.  Each files has
> phrases that can be put in front of a city or behind a city to make up a
> phrase which can eventually be searched for.  So these two files have a
> phrase, a product indicator, and a generic indicator.
>
> The idea is to use the variables in the first file to chose a group of
> cities.  Then attach each of the 93 phrases to each city, in the chosen
> group of cities, as a prefix or a suffix.
>
> Finally this data will be output as a csv or a dbf or a txt file.  The
> eventual idea is to let users, computer literate but not programmers, do
the
> selection.
>
> I am looking for thoughts on how to approach the selection process;
>
> I could just do the selection process myself in base SAS and never turn it
> over to the users.  That is a possibility.
>
> I would very much appreciate your thoughts on other approaches.
>
> Thanks
> Dave
>
> Dave Fickbohm
> Data Mining Analyst
> Homegain+
> 2450 45th St.
> Emeryville, CA, 94608
> Phone 510 655 0800 ext 4151