Using Password-Protected SAS Files in DATA and PROC Steps

To access password-protected files, use the same data set options that you use to assign protection.

   /* Assign a read and alter password        
   /* to the stored program file*/ /*STORED.SOURCE */  
   data mylibname.schedule / pgm=stored.source  
      (read=green alter=red);     <... more data step
statements ...>     
run;

   /*Access password-protected file*/
proc sort data=mylibname.score(write=yellow alter=red);
   by number;
run;

   /* Print read-protected data set MYLIBNAME.AUTOS */ 
      proc print data=mylibname.autos(read=green); run;

   /* Append ANIMALS to the write-protected */
   /* data set ZOO */
proc append base=mylibname.zoo(write=yellow)
            data=mylibname.animals;
run;

   /* Delete alter-protected data set MYLIBNAME.BOTANY */
proc datasets library=mylibname;
   delete botany(alter=red);
run;

Passwords are hierarchical in terms of gaining access. For example, specifying the ALTER password gives you read and write access. The following example creates the data set STATES, with three different passwords, and then reads the data set to produce a plot:

data mylibname.states(read=green write=yellow alter=red);
   input density crime name $;
   datalines;
151.4 6451.3 Colorado
... more data lines ...
;

proc plot data=mylibname.states(alter=red);
   plot crime*density;
run;

Chapter Contents
Previous
Next
Top of Page