SAS/IntrNet htmSQL

htmSQL Movie Poll Sample Setup

1. Copy the data.sas from the /sasweb/IntrNet9/htmSQL/movies directory to a working directory on your SAS/SHARE server system. For the following steps we assume the working directory is !SASROOT/intrnet/sample. On UNIX systems you might use !SASROOT/samples/intrnet instead.

2. Start a SAS session and submit the following statements:

   libname movies '!SASROOT/intrnet/sample';
%inc '!SASROOT/intrnet/sample/data.sas';

   The data.sas program will create working data sets for this sample in the directory defined by the LIBNAME statement.

3. Define the new SAS library to a SAS/SHARE server with a LIBNAME statement like the one above. You can test this in an interactive SAS session by submitting:

   libname movies '!SASROOT/intrnet/sample';
proc server id=__5002 authenticate=optional;
run;

   where 5002 is the TCP port to be used by the SAS/SHARE server. Be sure that the port you choose is not in use by another application on your system.

4. Edit the htmSQL input (.hsql) files in the /sasweb/IntrNet9/htmSQL/movies directory, changing the value of server=host.service in the {query} and {update} directives to specify the appropriate host and service name for the SAS/SHARE server you started in the previous step (for example, server=yourserver.5002).

   Also change the address in the mailto: links to send mail to your address in the event of errors.

5. Try out the Movie Poll sample.