In the new session I dont want to write any code as the view is meant to be accessible to people that do not know the password, They want to directly open it in SAS on a new session successfully without it requiring a password ... View more

yes this is the message i get when opening it in a new session:ERROR: SQL View WORK.V_CLASS could not be processed because at least one of the data sets, or views, referenced directly (or indirectly) by it could not be located, or opened successfully. ... View more

its got it there libname mydata "/fin/feb22"; anyway, when I run the code, it sets the password on the view and the dataset. I only want the password on the dataset. Not the view. ... View more

SAS EG. libname mydata "/fin/feb22"; /*Add password to dataset*/ data mydata.feb01(pw=x3jk); set mydata.feb01; run; libname myview "/vw_fin/feb_vw"; proc sql; create view myview.febvw as select * from mydata.feb01(pw=x3jk); run; ... View more

I think you are misunderstanding. I don't use a work lib. I use my own library path stored on my machine and when I try opening the view in a new session from that library, I get the error. There is no log when trying to open the dataset etc. as I use the file menu options. ... View more

there is no log because all I do after using your code for example is I open a new session and point to the lib where the view is and it cant open without a password. Below error message: SQL View mylib.dataset1 could not be processed because at least one of the data sets, or views, referenced directly (or indirectly) by it could not be located, or opened successfully. ... View more

Correction on your message. This is what I want: 1. Create a password protected dataset 2. Create a view of the dataset (NOT password-protected) ... View more

I understand that I need to specify the underlying password for the dataset when I create the view. The problem is the password remains on the view such that when I open the view in another session, it is password protected. I don't want the view to be password protected. I have tried the 'modify' clause but that didn't remove it because when I open the view in another session, it gives an error message. ... View more

yes the issue is the password. I have correctly assigned the libref in a new session and the view doesn't open. Thus my reason for asking for assistance 🙂 ... View more

hi there, So I have a dataset with a password on it. When I create the view, I don't want any password on it. I have tried your suggestion of: proc datasets library=work ; modify v_class(pw=foo2/); quit ; however when I use your suggestion and open the view in another SAS session I still get the same error message: SQL View mylib.dataset1 could not be processed because at least one of the data sets, or views, referenced directly (or indirectly) by it could not be located, or opened successfully. I want the password to be completely removed from the view no matter how I open the view and at any time. This is so multiple users can use the view instead of the main dataset. ... View more

Hi there, my SAS dataset has a password on it and I have a view of that dataset.   How do I remove the password from the view and not the main dataset?   I have tried the below however when I try opening the file it gives an error message: proc datasets library= mylib; modify dataset1 (pw=mypw/); run; quit; Error: SQL View mylib.dataset1 could not be processed because at least one of the data sets, or views, referenced directly (or indirectly) by it could not be located, or opened successfully.   Alternatively, I can create the view again but I don't want it to create with a password. it is very important that the main dataset has the password.  ... View more