LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2000, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page