Chapter Contents |
Previous |
Next |
SAS/ACCESS Software for PC File Formats: Reference |
Follow these steps to create a SAS/AF application that uses a view descriptor:
proc access dbms=dbf; /* create access descriptor */ create adlib.employ.access; path='c:\sasdemo\employee.dbf'; assign=yes; format empid 6.0 salary dollar12.2 jobcode 5.0 birthdate date9. hiredate date9.; list all; /* create vlib.allemp view */ create vlib.allemp.view; select all; run;
libname scllib 'SAS-data-library'; /* assign a libref */ /* create the catalog entry */ proc build catalog=scllib.employee.example.program; run;
DISPLAY Window for EXAMPLE Application
After designing the DISPLAY window, open the
ATTR window
(with the ATTR command) and change the default values for the
ID
and
PHN
attributes. The type for
ID
should be changed from
CHAR
to
NUM
.
The
&PHN
field is shown in ATTR Window for EXAMPLE Application. Notice that the field name
PHN
is assigned to the variable
PHONE
, which is listed
as the alias. This variable is only four characters wide (as shown in the
Length
field) but the name
PHONE
is five characters
long. Therefore, a shorter field name is assigned--three characters (
PHN
) plus the
&
. For more information about
window attributes, refer to the online help information for SAS/AF software.
ATTR Window for EXAMPLE Application
Issue the SOURCE command to open the SOURCE window so that you can enter the SCL program into it, as shown in SCL Program for the Source Window.
SCL Program for the Source Window
/* SCL program to be added to the Source window */ INIT: /* Open the view descriptor VLIB.ALLEMP for reading (input mode) */ dsid=open('vlib.allemp','i'); call set(dsid); return; MAIN: /* When an employee id is entered, subset the view */ /* descriptor and fetch in values for the employee's */ /* first name, last name, and phone extension */ if modified(id) and id ne _blank_ then do; rc=where(dsid,'empid = '||put(id,6.)); rc=fetch(dsid); if rc ne 0 then _msg_ = 'Employee id not found. Please re-enter'; end; return; TERM: /* Close the view descriptor */ if (dsid > 0) then dsid=close(dsid); return;
Compile and test the program. Your SAS/AF application window is displayed. Enter an employee's ID (EMPID) from EMPLOYEE.DBF, as shown in User's View of the Application.
User's View of the Application
Press ENTER and the employee's name and phone extension are automatically supplied from the DBF file, as shown in PC Files Data Supplied by the Application.
PC Files Data Supplied by the Application
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.