Date:         Fri, 2 Aug 1996 20:55:44 GMT
Reply-To:     "John M. Rinehart" <74134.3135@COMPUSERVE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "John M. Rinehart" <74134.3135@COMPUSERVE.COM>
Organization: CompuServe Incorporated
Subject:      ?? SAS/SHARE and Format Libraries

Hi all,
 
I'm using SAS/SHARE to access SAS datasets on an OpenVMS system,
SASver6.08.  I'm attempting to view/edit a subset of a dataset with
FSVIEW/FSEDIT and a WHERE stmt, and I am using a user-defined Format
in a PUT() function as part of the WHERE expn (e.g: WHERE
put(var1,$fmt1.)='cccc';).   This technique works great for selecting
on lookup values rather than values actually stored on the dataset.
However, when I try to use this on a dataset accessed through a
SAS/SHARE server, I get " ERROR: Format $fmt1 not found."   I've tried
putting the user-defined formats in LIBRARY.FORMATS (both through the
server, and not), WORK.FORMATS, and in a catalog named in OPTIONS
FMTSEARCH, all with same result.  I assume the problem is that the
WHERE processing is being done in the server process, which doesn't
'see' the format library references in the user process.
 
Any ideas?  Thanks.
 
John M. Rinehart
3280 Skytop Trail, Dover, PA 17315
(717) 292-1636
 
74134.3135@compuserve.com