Learning SAS? Welcome to the exclusive online community for all SAS learners.

Lockdown state

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Lockdown state

my code

PROC IMPORT DBMS=xls OUT=eia
DATAFILE="/SASUniversityEdition/myfolders/MutualFunds.xls";
RANGE="Data 1$A2:I869";
GETNAMES=NO;
RUN;

ERROR: The path /SASUniversityEdition/myfolders/MutualFunds.xls is invalid because it is not in the list of accessible paths when
SAS is in the lockdown state.

Guys i m a novice in SAS and trying to learn it can you please help me with the code where m i going wrong

using SAS university edition using vmware player ver7


Accepted Solutions
Solution
‎12-16-2014 04:25 PM
Super User
Posts: 17,907

Re: Lockdown state

Replace SASUneiversityEditon with folders in the path name.

Yes the the path is actually as you have it, but it needs to be called folders.

What does lockdown state have to do with your question?

View solution in original post


All Replies
Solution
‎12-16-2014 04:25 PM
Super User
Posts: 17,907

Re: Lockdown state

Replace SASUneiversityEditon with folders in the path name.

Yes the the path is actually as you have it, but it needs to be called folders.

What does lockdown state have to do with your question?

SAS Employee
Posts: 146

Re: Lockdown state

Reeza did a good job of answering the question, but I wanted to add a little more.  If you've set up a shared folder called myfolders, then you have the use of the following path in your SAS code:

/folders/myfolders

If you've set up any other shared folders (see How do I create a folder shortcut to my existing SAS files?  ) then you'll have those paths to use in your SAS code:

/folders/myshortcuts/folder-name

If you try to use any folder paths that aren't in those folders trees, then SAS thinks you want to write to directories that are actually in the virtual machine itself.  Remember, the University Edition is really running SAS on Linux inside that vApp.  That's not something you want to do (besides being hard to manage, you really want the vApp to be disposable & keep everything you care about on your local machine).  To help with that, we set up SAS running in the virtual machine in a lockdown state.  If you want to know the gory details about what lockdown is, see the helpful blog at http://blogs.sas.com/content/sasdummy/2014/02/21/using-lockdown-sas94/  .  That's why you get the weird lockdown message.

Occasional Contributor
Posts: 17

Re: Lockdown state

Hi
Amy
I too got an error while trying to print a PDF version of my report, I even wonder if that is even right.
below is the code
ods pdf file= '/users/clairekim/documents/ch01.pdf';
proc print data= work.newemployees label split='*';
label Tittle = 'Heading * the book' LName ='Last Name';
format salary dollar9. ;
title " The New Employees";
footnote "&sysday &sysdate9 by &sysuserid";
run;
ods pdf close;
can you help me too with this please .
New Contributor
Posts: 4

Re: Lockdown state

Amy,

 

I still can't get it to work.  I understand that I've somehow set up the directory reference incorrectly. 

 

However I've copied the pathname, and put that into the datafile parameter.   Not sure what more is needed, nor why it's so difficult?

 

Any help would be appreciated.

 

Regards

 

snippet below for reference

 

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
61
62 /** Import an XLSX file. **/
63
64 PROC IMPORT DATAFILE="/Folders/myfolders/ofxdownload.csv"
65 OUT=WORK.Van_Trans
66 DBMS=CSV
67 REPLACE;
68 RUN;
 

ERROR: The path /Folders/myfolders/ofxdownload.csv is not in the list of accessible paths when SAS is in the lockdown state.

 

 

New Contributor
Posts: 2

Re: Lockdown state

thank you Reeza & AmyP you were of great help

New User
Posts: 1

Re: Lockdown state

Just a note: contrary to the instructions, a refresh whilst sharing a data folder won't suffice: need to logoff and exit the virtualbox machine to have the new shared folder visible. [Linux Mint 17.3, virtualbox OSE 5.04, SAS UEvApp
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 2214 views
  • 3 likes
  • 6 in conversation