Set permissions when creating a dataset

[tariqhali2]

Hello,

I am trying to figure out how to set permission while creating a dataset. If that is not possible how do I change permission to dataset that I have already created.

I use pc sas and the datasets are usually on a UNIX box so permission will be something like 775 or 777.

PROC SQL;
CREATE TABLE TABLE_NAME AS /* Is it possible to set permission here */
SELECT * FROM DATASET;
QUIT;

Thanks.

 

[kdt82]

Hi Tariq,

When creating the dataset you have the ability to password protect aspects of it. For example, you can set separate passwords for reading, writing and altering the dataset/view. Alternatively, you can use the pw keyword to assign a full lock on your dataset.

data misc.class(pw=t3432) ;
   set sashelp.class ;
   run;
proc print data=misc.class(pw=t3432);
   run;

Try substituting pw= with read/write/alter= to see the effects.

If your datasets are stored on a unix box, you can also stick an x command after you create the dataset to apply the desired permissions from within SAS:

x "chmod 744 %sysfunc(pathname(MISC))/class.sas7bdat" ;