Date:         Fri, 4 Feb 2000 12:12:58 -0500
Reply-To:     "Fehd, Ronald J." <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J." <rjf2@CDC.GOV>
Subject:      info: passwords
Content-Type: text/plain; charset="iso-8859-1"

MPRINT(UCHNGPW):   proc DATASETS library = LIBRARY nolist;
MPRINT(UCHNGPW):   modify Q9911WD1(
MPRINT(MPEPPASS):  write = / WXYZ alter = ABCD pwreq = NO
MPRINT(UCHNGPW):  );
MPRINT(UCHNGPW):   run;

YeeeowZa! been pulling my hair out this morning getting this macro straight
to add passwords to a data set with both data set options and using proc
DATASETS.

differences:
data X(write = NEW-WRITE-PASSWORD alter=NEW-ALTER-PASSWORD);

now trying to mess with data X and apply PWs w/proc DATASETS.
one has to know the old PW in order to change it.
imagine my surprise!?
and the kludge -- if you don't remember the old PW -- is the slash.
see the MPRINT above
modify DSN(write <OLD-WRITE-PW> / NEW-WRITE-PW alter = NEW-ALTER-PW;
NOTE that the slash must be used to assign the write PW, but no slash for
the new alter PW.
NOTE: no quotes needed around PWs.

RTFM: SAS Tech Report P-222 "The Brown Bible" C&E to Base SAS Software R6.07
Ch 2  SAS Files, passwords
Ch 23 proc DATASETS, modify statement, manipulating PWs
<gak> :-@
Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2@cdc.gov